SOLVED

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

 

Help.

6 Replies
best response confirmed by Cheryl4242 (New Contributor)
Solution

@Cheryl4242 

 

Hi Chery,

You can use CountA() function. Please refer attached file.

Thanks,

Tauqeer

CountA1.JPG

 

@tauqeeracma  THANK YOU SO MUCH!  I didn't even know this was an option!  Thank you!

@Cheryl4242 

COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like

=COUNTIF(G3:G20,"<>")

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

@SamCano , glad to help

This was really helpful...thank you

@Sergei Baklan