Stefi,

this worked great except most of the range is blank with no date...the
formula works great on February-December (2-12)...however, all of the blank
cells are ending up counted as if having a January date (=1)?

"Stefi" wrote:

If date column is A:
=SUMPRODUCT(--(MONTH(A1:A10)=1))
Adjust range to the last row!
Regards,
Stefi


€žjoe@malvern€� ezt Ã*rta:

I would like to search and countif a column with dates (MM/DD/YYYY) counting
if the month is January "01". How do I do this

thanks