Forum Discussion
Excel
All I want is when I write a date I want the sheet to add 30 days and if it's today or greater than today I want it to write"cycle 1" if it equals that date +60 days I want it to write "cycle 2" and i...
Let's say you enter a date in cell A2. In another cell, for example B2, enter the formula
=IF(A2+30>=TODAY(),"Cycle 1",IF(A2+60>=TODAY(),"Cycle 2",IF(A2+90>=TODAY(),"Cycle 3","")))
- I've tried that but it didn't work..
