May 29 2022 11:48 AM
Date | Status |
12/05/2022 | Completed |
12/05/2022 | Rescheduled |
29/03/2022 | Booked |
I am trying to make the date regenerate 90 days from todays date, whenever the status is marked "Completed".
I have tried to do this with the IF function, but I an struggling with it.
Is there a way to do this? - Thanks in advance
May 29 2022 12:00 PM
May 29 2022 12:16 PM
May 29 2022 12:57 PM
This is probably with the worksheet change event. In the attached file you can enter "Completed" in any cell in range B2:B100 and todays date + 90 days will be entered in the adjacent cell. The date will remain if you change the cell in column B from "Completed" to "Booked" or else. However if you enter "Completed" again tomorrow the date in column C will be updated.