I need help with calculating start dates and end dates when a single row has 16 stages.
I have 16 stages for each row. The picture below shows a sample of the first 4 stages. Each stage must be started after the previous stage is completed. I want to create a formula for dates to exclude weekends and holidays. For each of the 16 phases, I have a start date column and due date column. I know how long each phase should take to complete. I'm not sure how to get the dates to automatically populate once I add the first start date.
Answers
-
The first thing I would think is to ask if you are leveraging the dependencies (predecessor & durations) and the project settings to set your working days (m-f) and your holidays are included in the "Non-working days" section.
-
I am leveraging the dependencies. I'm struggling with how to leverage dependencies for multiple columns that pertain to each row.
-
I'm not sure that's how they are designed. Perhaps there would be a formula that could populate or count/add dates as you proceed "to the right" instead of "down"?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!