Forum Discussion
Solved
COUNTIF to count cells with dates in them
It's so simple, but I can't make it work.... I have a column where a date will be entered for some cells. I just want to count the cells with dates in them. The other cells will be blank. I've tr...
COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like
=COUNTIF(G3:G20,"<>")
This was really helpful...thank you