指定上月日與本月日 為本月 計算次數 (14531)

G2=SUM(COUNTIFS(D:D,"<"&EOMONTH(DATE(B$2,LEFTB(F2,2),),{-1,0})+21)*{-1,1})

H2=INDEX(FREQUENCY(D:D,K2:L2-{1,0}),2)

K2:L13=EOMONTH(DATE($B$2,LEFTB($F2,2),),COLUMN(A1)-2)+22-COLUMN(A1)