formula needed for counting months

Shocked · Nov 17, 2004

I have a column of dates formated mm/dd/yyyy. I need a formula tha
will count the number of occurances for, say, January.

Any ideas

Frank Kabel · Nov 17, 2004

Hi
0SUMPRODUCT(--(MONTH(A1:A100)=1),--(A1:A100<>""))

Max · Nov 17, 2004

Assume the dates are in A1:A100
Try: =SUMPRODUCT(--(MONTH(A1:A100)=1))
to count occurences for January ("1")