How to review a column of dates and count the rows that are not a date

cabbsman

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.

Eric Law

https://community.smartsheet.com/discussion/114286/how-to-review-a-column-of-dates-and-count-the-rows-that-are-not-a-date

Try this instead =COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, NOT(ISDATE(@cell)))

cabbsman

That did it! Thank you.

Eric Law

https://community.smartsheet.com/discussion/114286/how-to-review-a-column-of-dates-and-count-the-rows-that-are-not-a-date

Try this instead =COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, NOT(ISDATE(@cell)))

cabbsman

That did it! Thank you.