Formula to deduct calender days from a date, holding weekends in account


for example:

date is 09/06 - need to deduct 10 calenderdays, the date returned may never be saterday or sunday.

the outcome must be 01/06 - since 10 calenderday returns Sunday 31/05 - which is not allowed.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!