How to write a COUNTIF formula that counts the amount of rows where the date is TODAY-date>80 AND

Answers

  • Lidiya S.
    Lidiya S. ✭✭✭

    Hello @Abbie G

    Try this:

    =COUNTIFS([Column20]:[Column20], >TODAY(+80), [Column20]:[Column20], <TODAY(+99))
    
    

    Just replace [Column20]:[Column20] with the column that your Date is in.

    Let me know how it goes!

    Lidiya Shutaya

    lidiya@ddbconsultants.ca

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!