Calculate Kick Off Date based on Go Live date - Duration

AshleyJones

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.

SmartsheetFunction.png

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

Paul Newcome

Honestly you have a lot of stuff you really don't need. Let's try cleaning that up first to see what happens.

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