| 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