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