Try this formula (set the month number, 10 in this case, as needed)...

=SUMPRODUCT(--(MONTH(A1:A4)=10))

--
Rick (MVP - Excel)


"JRD" wrote in message
...
How can I count the number of cells in date format which contain a certain
month

Example:
A
1 01/10/2009
2 01/09/2009
3 20/09/2009
4 12/10/2009

How can I count the number of cells in column A which contain an October
date. The answer here would be 2.

Thanks