Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Thiết lập:
A1=2020
AN1="SUN" hoặc "MON"
Tác giả: T.D.Nguyen
Rút gọn: N.D.Thanh
=ArrayFormula({
{"\/";TEXT(DATE(A1,ROW(1:12),1),"mmmm")}
,{
UPPER(TEXT("1/1/2018"+COLUMN($A$1:$AP$1)-(1+(AN1=TEXT(DATE(2017,1,1),"ddd"))),"DDD"));
TEXT(WORKDAY.INTL(DATE($A$1,row(1:12),1)+1,-1,IF($AN$1=TEXT(DATE(2017,1,1),"ddd"),"1111110","0111111"))-1+COLUMN($A$1:$AP$1),"[<"&DATE($A$1,row(1:12),1)&"];[>"&DATE($A$1,row(1:12)+1,0)&"];DD")
}
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.