One way:

=SUMPRODUCT((MONTH(A1:A100)=1)*1)
=SUMPRODUCT((MONTH(A1:A100)=2)*1)
:
:
=SUMPRODUCT((MONTH(A1:A100)=11)*1)
=SUMPRODUCT((MONTH(A1:A100)=12)*1)

Assuming the dates are in cells A1 to A100; note it has to be a range and
not the whole column

Regards

Trevor


"MacAttack" wrote in message
...
I have spread sheets with data that covers the entire year. I want to be
able to look up and count the dates for each month. Dates are written in
11/30/06 format. I appreciate any assistance I can get.