How to review a column of dates and count the rows that are not a date
I have a use case where I have a list of dates and need to count the number of rows that do not have a date in the column. For example,
12/01/23
12/02/23
12/03/23
Active
12/05/23
Not Active
12/07/23
(space or blank)
12/08/23
12/09/23
12/10/23
In this example, the number of non-dates in the column should be 3. I believe I need to use a ISDATE() function but for the entire column. Below is the formula I have that doesn't work in my source sheet.
=COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, <> ISDATE(@cell))
Where,
"Node List - Node Activation Date" is a list of dates in a column (with a date property) on my target sheet that is in the list of dates format like the example above.
"[Hub Name]@row" on my source sheet should match the "Hub Name" on my target sheet.
Thank you.