Formula Within Next 30, 60, 90 days

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello -

Looking for help with a basic formula that will calculate how many projects end within a certain number of days. 

I have used: =COUNTIF({End Date}, <=TODAY(30)) 

I am not receiving an error message, but the result is much higher than the number is should be. 

Any help you can provide is appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!