萬年曆 周日開始 (13546)

A4:G4=TEXT(COLUMN(A1)-WEEKDAY(DATE($A1,$C1,1),1)+1,"0;;")

A6:G6=IFERROR(IF($G4+COLUMN(A1)>DAY(EOMONTH(DATE($A$1,$C$1,1),0)),"",$G4+COLUMN(A1)),"")

A6:G6複製到A8:G8 A10:G10 … A14:G14



留言