Counting Dates less than 90 days from today

Options

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

Tags:

Answers

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    Options

    Hello @Tony Cooper

    Would this work?

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

    Peggy

  • Tony Cooper
    Tony Cooper ✭✭✭
    Options

    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
    Peggy Parchert ✭✭✭✭✭✭
    Options

    @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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!