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

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!