入職與離職之間 各年投保月數 (14979)

L3:L21=IFERROR(DATEDIF(EOMONTH(EDATE(G3,(DAY($G3)>=23)*1),-1)+1,EOMONTH(EDATE(I3,(DAY($I3)<15)*-1),-1)+1,"M")+1,)

M3:R21{=COUNT(MATCH(DATE(M$2,ROW($1:$12),1),EDATE(EOMONTH(EDATE($G3,(DAY($G3)>=23)*1),-1)+1,ROW(INDIRECT("1:"&$L3))-1),))

(驗證用)F3=TEXT(EOMONTH(EDATE(G3,(DAY($G3)>=23)*1),-1)+1,"YYY/M/D")

(驗證用)H3=TEXT(EOMONTH(EDATE(I3,(DAY($I3)<15)*-1),-1)+1,"YYY/M/D")