每月各周 1日與月底必須顯示 (12201)

D2下拉{=IF(ROW(A1)=1,DATE(B$2,1,1),MIN(EOMONTH(D1,0)+1,MAX((WEEKDAY(D1+ROW($1:$7),2)=1)*(D1+ROW($1:$7)))))

E2下拉{=MIN(EOMONTH(D2,0),MAX((WEEKDAY(D2+ROW($1:$7)-1,2)=7)*(D2+ROW($1:$7)-1)))