Counting Blank Date Cells

EmilyE

I think I am missing a piece. We would like to count blank Date cells. Is this possible? Any variations of Count Ifs I am trying don't work. I think perhaps I am missing something, as this should be straight forward in my head...

Thanks for any thoughts or guidance!

Stefan

Hi @EmilyE ,

how about:

=COUNTIF([original date]1:[original date]9, ="")

[original date]1:[original date]9 = the range of cells you want to check.

Hope this helps

Stefan

Stefan

Hi @EmilyE ,

how about:

=COUNTIF([original date]1:[original date]9, ="")

[original date]1:[original date]9 = the range of cells you want to check.

Hope this helps

Stefan

EmilyE

That worked!

Thank you! I knew I was missing something simple ( like an = sign :) )

Stefan

Happy to help

Greetings

Stefan