Count occurance of a month in a column of dates?

S

Stormy

In Excel I'm trying to count the number of times a given month occurs in a
column of values of the type date.
 
P

Peo Sjoblom

=SUMPRODUCT(--(ISNUMBER(A2:A500)),--(MONTH(A2:A500)=2))

would count February


=SUMPRODUCT(--(ISNUMBER(A2:A500)),--(YEAR(A2:A500)=2007),--(MONTH(A2:A500)=2))

would count February 2007
 
Top