counting dates (months) using SUMPRODUCT

[Marge]

I have a column with 100 rows that will eventually contain a publication
date. Those cells are formatted as dates. Some of the cells in the column
have dates and I need to count the number of publication dates in July,
August, etc. I'm using the formula

=SUMPRODUCT(--(MONTH(A1:A100)=7))

[7 being the number that represents July] and the formula yields the number
of publication dates in July.

My problem is that the formula is counting every blank cell as a January date.

Any help you can give is greatly appreciated.

 

[Marge]

This was erroneously posted to the Access group page....my apologies.