formula that when completed next start date is +330 days
I am trying to figure a formula that when I actually complete something, that the start date row will trigger the next time it needs to be done.
I have start date, due date, and actual complete date.
Start date would be 2/1/21, with a due date of 2/15/21.
I'm then filling in when the task is actually completed, which hopefully will be close to due date. Say it was 2/16/21. I would like the next start date to reflect a new date to start of +330 days.
Plan is to use this for annual program review. Set reminder to review it, time to get done, when it actually gets done then auto generate new start date for next year to do all over again.
Unless someone has a better way to structure this, I am open to suggestions.
I have 15+ programs to monitor and ensure they get reviewed annually (along with some other tasks that repeat as well).
Appreciate any feedback. THANK YOU !
Help Article Resources
Check out the Formula Handbook template!