Count all cells in a column that are NOT blank and do NOT contain a date

Terrell.Boaz52986

Hi,

I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your assistance.

Mike Wilday

Try this one: 

=COUNTIFS([Column Header]:[Column Header], NOT(ISDATE(@cell)), [Column Header]:[Column Header], NOT(ISBLANK(@cell)))

Replace Columnn Header with the name of the column you want to check. 

Terrell.Boaz52986

This is perfect, thank you so much.

 

Mike Wilday

Awesome! I am glad I could help you out.