How to build an IF formula based on a date field

Talie ✭✭
edited 07/27/22 in Formulas and Functions


I am looking for help in building an IF formula that will return a number value, based on how far in the past a date is (using a date field).

Where a date field is populated and depending on the date, a number will be chosen :

1 = a date that falls in the last 2 months from today

2 = a date that falls between 2 and 4 months from today

3 = a date that falls between 4 and 6 months from today

4 = a data that falls between 6 and 8 months from today

5 = a date that is greater then 8 months from today

The only part I've figured out is to use the VALUE function so my other formulas read the field.

Any help would be greatly appreciated!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!