Calculate start date based off of end date
Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date and duration of project. However, if I have an already defined end date I'd like to calculate the start date based off of the pre-defined end date and duration of project.
Use Case: non-negotiable end date of July 1, 2024. Project is 10 weeks long. What date should the project begin to meet that end date?
Thank you all for your help!
Tammy Sutton, CSM, CSPO
Project Manager | MilkTracker
Help Article Resources
Check out the Formula Handbook template!