Calculate Kick Off Date based on Go Live date - Duration

Options

Hi,


I am trying to create a formula that will allow me to enter a Go Live Date, have the function calculate the work days needed to hit the go live date, and present the date that the project needs to start on.

I hope the picture helps. For whatever reason I keep getting incorrect dates appear in the Go Live task

The function in the image is as follows

=WORKDAY(GoLiveDateCalculation4, VALUE(ROUNDUP(0 - SUM(Duration2, Duration45, Duration155), 0)))


If anyone can help me get this Go Live Date accurate that would be amazing.

TIA

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!