Calculate work days in formula, excluding weekends


I have three columns, Projected Hours to complete a task, Start Date and Finish Date. I have a Vlookup that populates the projected hours cell based on a product group identifier. Someone then enters a start date and i have a formula in the finish date cell that calculates the end date based on the projected hours. I would like this finish date cell to exclude weekends and non work days. Is there any way to do that with a formula? I know Smartsheet has built in features that accomplish this with Project Settings, unfortunately this did not produce our desired result in our workflow solution leading me to come up with a work around.

Any help would be appreciated.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!