Calculating days formula that ends in a working day

Hello community,

As the title explains, I am looking for a formula that adds 30 days to a specific date. However, sometimes these dates are during the weekend. I want a formula that would be able to add 30 days to a date. If that answered date is on a Saturday or Sunday, it will go to the closest working date. Please let me know if you need any more info. Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!