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".
View best response
You can use CountA() function. Please refer attached file.
@tauqeeracma THANK YOU SO MUCH! I didn't even know this was an option! Thank you!
COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like