Forum Discussion
Excel
5 Replies
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.
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..
