Counting Dates less than 90 days from today

Tony Cooper

Hi there. I'm trying to write a formula that will tell me how may dates are less than 90 days from today. Here is what I thought should work, but it doesn't. I feel like I'm close. What am I missing? Here is the formula I have.

=COUNTIF([Start Date]:[Start Date])@row, TODAY-90)

Thank,

Tony Cooper

Peggy Parchert

Hello @Tony Cooper

Would this work?

=COUNTIF([Start Date]:[Start Date], TODAY() - 90)

Peggy

Tony Cooper

Hi Peggy,

Thank you. This is closer. Not it at least returns a value, but not the expected value. I know there are cells where the date is less than 90 days from today, however this returns a 0.

Thanks,

Tony

Peggy Parchert

@Tony Cooper

Good morning. I think I have a solution. See if this would work:

TODAY Helper column is an automation workflow (record a date) that runs daily.

90 Days Ago is a column formula: =[Today Helper]@row - 90

Start Date column is manually entered 🤷‍♀️

countif helper column is a column formula column: =COUNTIF([Start Date]@row, <[90 Days Ago]@row)

count (this could be a Sheet Summary field) contains formula: =COUNTIF([countif helper]:[countif helper], 1)

Peggy