Forum Discussion
Excel
I cannot figure out how to write the following formula so Excel will accept it:
If I2 is >92 I want it to take today/s date plus 90 days
If I2 is between 85 and 92 then it should take today's...
Pamela,
Try this formula:
=IF(I2>92,EDATE(TODAY(),3),IF(AND(I2>=85,I2<=92),EDATE(TODAY(),2),IF(I2<85,EDATE(TODAY(),1))))