Recurring tasks that need their due date to update regularly
I am creating a sheet to manage our facility life safety inspections.
Some of them occur monthly, some occur weekly, others semi annually and others annually or more.
What I am hoping to do is create a formula that will update the due date to the next date, after the current inspection has been completed.
I plan to have the completed date entered via an update request.
Is this possible? Or am I dreaming?
Thank you for any wisdom or grounding if I am hoping for too much!
Help Article Resources
Check out the Formula Handbook template!