07-11-2019 12:01 PM
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 tried to use the * to count any value in a cell,=COUNTIF(G3:G20,"*") and that didn't work.
Is there some variation that will count date values? The column in question is formatted as "DATE".
Help.
07-11-2019 12:26 PM
Solution07-11-2019 12:38 PM
@tauqeeracma THANK YOU SO MUCH! I didn't even know this was an option! Thank you!
07-11-2019 01:30 PM
COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like
=COUNTIF(G3:G20,"<>")
Thursday
@Sergei Baklan thank you!! That´s what I was looking for!!!