one_formula_calendar_short.txt

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")
        }
})