二格日期 合併一格 (10515)

B2:C2 右拉 AG2=IF(COLUMN(A1)>DAY(EOMONTH($B1&-1,0)),"",YEAR(NOW())&"."&$B1&"."&COLUMN(A1))&IF(COLUMN(B1)>DAY(EOMONTH($B1&-1,0)),"","-"&COLUMN(B1))

B5:B21=IF(ROW(A1)*2-1>DAY(EOMONTH(B$1&-1,0)),"",YEAR(NOW())&"."&B$1&"."&ROW(A1)*2-1)&IF(ROW(A1)*2>DAY(EOMONTH(B$1&-1,0)),"","-"&ROW(A1)*2)