How to add duration to manually entered current expected date without adding weekends?

bagoston

I am adding a column to my plan titled "Current Expected Finish". This column will be used when a task is going to be behind. For the first task behind, an expected finish date will be added to this column. I then want to automatically calculate how that affects the remained of the task. To do this, I want to take the new current expected finish date and add the duration for the next task to populate the next current expected finish date. However, my new current expected finish column is including weekends. How do I remove the weekends?

Leroy Noriega

Use the WORKDAY function.

https://help.smartsheet.com/function/workday

bagoston

I have tried it. However, it comes up with an error. Below are two ways I tried it. Any help with the formula would be appreciated.

bagoston

I found a posted solution. Not sure why it works, but it does.