Calculate start date based off of end date
Hi All,
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
AngelEye Health
Best Answers
-
Thank you @heyjay I appreciate your answer. That will get me a date for just a single cell. I'm wondering about a more automated date that I can make a column formula based off of end date - duration = start date.
I appreciate your help.
Tammy Sutton, CSM, CSPO
Project Manager | MilkTracker
AngelEye Health
-
Ohhhh, I just learned that with the current dependency setup. If I put in the start date and the duration it configures the end date. BUT.....if instead of putting in the start date I put in end date and the same duration it works backwards. SIGH, should have tried that prior to posting my question.
Thanks all!
Tammy Sutton, CSM, CSPO
Project Manager | MilkTracker
AngelEye Health
Answers
-
=date(2024,7,1) - 70
70 is 10weeks x 7days (in a week). You can replace the date function is you have a reference cell.
date@row
...
-
Thank you @heyjay I appreciate your answer. That will get me a date for just a single cell. I'm wondering about a more automated date that I can make a column formula based off of end date - duration = start date.
I appreciate your help.
Tammy Sutton, CSM, CSPO
Project Manager | MilkTracker
AngelEye Health
-
-
Ohhhh, I just learned that with the current dependency setup. If I put in the start date and the duration it configures the end date. BUT.....if instead of putting in the start date I put in end date and the same duration it works backwards. SIGH, should have tried that prior to posting my question.
Thanks all!
Tammy Sutton, CSM, CSPO
Project Manager | MilkTracker
AngelEye Health
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!