COUNTIF to count cells with dates in them

[Cheryl4242]

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.

[#2 · Accepted solution]

@Cheryl4242 

Hi Chery,

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

Thanks,

Tauqeer

[#3]

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

[#4]

@Cheryl4242 

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

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

[#5]

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

[#6]

@SamCano , glad to help

[#7]

This was really helpful...thank you

@Sergei Baklan 

[#8]

@tauqeeracma This was a great help to me also.

Thank you,

Johnn557.