Just make the starting cell in the range A2 instead of A1.

--
Rick (MVP - Excel)


"JRD" wrote in message
...
Can I use this formula to look down a whole column where the first row is
not
actually a date (it is a heading)?

Thanks

"Rick Rothstein" wrote:

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

.