Hello,
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!
Natalie
