今天月曆 跨月自動 (12123)

K1=YEAR(NOW())

K2=MONTH(NOW())

B2:H2=IF(WEEKDAY(DATE($K$1,$K$2,1),1)<=COLUMN(A1),N(A2)+1,"")

B4:H4=IFERROR(TEXT(($K$1&-$K$2&-$H2-COLUMN(A1))*1,"D"),"")

B4:H4 複製到B6:H6 B8:H8 B10:H10 B12:H12