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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!