I need help with calculating start dates and end dates when a single row has 16 stages.

Tammy May

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.

Martha Hemingway

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.

Tammy May

I am leveraging the dependencies. I'm struggling with how to leverage dependencies for multiple columns that pertain to each row.

Martha Hemingway

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"?