月份數量 以今日計 (11421)

C3=SUMPRODUCT(N(TEXT(A3:A14,"EM")=TEXT(E2,"EM")))

另解=COUNTIFS(A:A,">="&EOMONTH(E2,-1)+1,A:A,"<="&EOMONTH(E2,0))

另解=NPV(-2,COUNTIF(A:A,"<="&EOMONTH(E2,{-1,0})))

另解=INDEX(FREQUENCY(A:A,EOMONTH(E2,{-1,0})),2)

另解=SUM(COUNTIF(A:A,"<="&EOMONTH(E2,{-1,0}))*{-1,1})