COUNTIF Function and Blank Date Cells

[Atkey]

I am attempting to generate a table that would show the number of dates in a column that are equal to or less that today' date. Some cells are blank and the formula is counting these blank cells. How would I get my formula to just count dates in the required range and ignore the blanks?

I am using =COUNTIF(M2,"<="TODAY())

Thanks in advance!

 

[Joe4]

48 is the ASCII code for the number 0.
Your formula should actually be returning a 0 then, and not a blank. Maybe you have Conditional Formatting or some custom formatting hiding the 0s.

Try this formula:

=COUNTIFS(M:M,"<="&TODAY(),M:M,">0")

 

[Atkey]

Thats fantastic, problem solved. Thank you all for you time and help.

 

[Joe4]

You are welcome.
Glad we were able to help.