Counting dates in a column

Zia Siddiqui

Hi, I am trying to count cells in a column to determine:

(a) which cells have dates in them? and

(b) which cells have dates in the past (older than today)

Would appreciate if anyone could provide some guidance.

Thanks.

Zia Siddiqui

Please ignore (b). Just looking for some direction on (a). Thanks

Jaykel Torres

Hey @Zia Siddiqui ,

You will want to use a combination of the COUNTIF, ISDATE, and @cell functions to count the number of date values within a given range. I have created the example below on how this may look like for your reference:

 

Formula: =COUNTIF(Date:Date, ISDATE(@cell))

I hope this helps!

Jaykel