COUNTIF to count cells with dates in them

New Contributor

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".



7 Replies
best response confirmed by Cheryl4242 (New Contributor)



Hi Chery,

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


@Sergei Baklan thank you!! That´s what I was looking for!!!

@SamCano , glad to help

This was really helpful...thank you

@Sergei Baklan 

@tauqeeracma This was a great help to me also.


Thank you,