Counting occurrences of specific month

B

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.
 
P

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
 
B

bpoland58

Thanks That does it.

Peo Sjoblom said:
=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
Click to expand...
 
Top