How to build an IF formula based on a date field
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!
Help Article Resources
Check out the Formula Handbook template!