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...
That's all but that's not enough.
" I want the sheet to add 30 days" - add to what? After added, where to return the result?
"I want it to write "cycle 1"" - write where?
"I want it to add "cycle 3" - add to what?
Better if you provide small sample file with manually added results to illustrate the question.
- Like this.. I want it after 30 days of the due date to write cycle 1 and after 60 days "cycle 2" and after 90 "cycle 3"
Cell D2 in your sample workbook contains a text value that looks like a date, not a real date.
You can convert existing values to real dates as follows:
- Select the cells in column D.
- On the Data tab of the ribbon, click Text to Columns.
- Click Delimited, then click Next >.
- Click Next > again.
- Under 'Column data format', select Date, then select DMY from the dropdown list next to Date.
- Click finish.
Enter the following formula in F2:
=IF(D2="","",IF(D2<=TODAY()-90,"Cycle 3",IF(D2<=TODAY()-60,"Cycle 2",IF(D2<=TODAY()-30,"Cycle 1",""))))
Fill down.
See the attached version.
