Counting occurrences of specific month

[bpoland58]

I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there any
way to count the number of times there is an entry for the month only. In
this example the month of Nov.

 

[Peo Sjoblom]

=SUMPRODUCT(--(ISNUMBER(A1:A20)),--(MONTH(A1:A20)=11))


if you get a value error then they are text and not numerical Excel dates


--


Regards,


Peo Sjoblom

 

[bpoland58]

Thanks That does it.

=SUMPRODUCT(--(ISNUMBER(A1:A20)),--(MONTH(A1:A20)=11))


if you get a value error then they are text and not numerical Excel dates


--


Regards,


Peo Sjoblom