counting dates (months) using SUMPRODUCT

  • Thread starter Thread starter Marge
  • Start date Start date
M

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.
 
Back
Top