Count # of Dates in a Cell - Minus Cells with Regular Text

PR

Hello, I'm trying to figure out the formula that counts all cells in a column with a date. However, I have some cells with "NA" and I would like to exclude that from the count.

Thank you so much for your help!

ker9

Hi @PR

Try this:

=COUNTIF([Column Name]:[Column Name], ISDATE(@cell) = true)

Hope this helps!