Formula for business days

aelmore
aelmore
edited 12/09/19 in Formulas and Functions

Hi!

 

Is there a way to do a formula calculating a date plus x no. of business days. For example, I need 7 business days from the time something was approved. Right now I have =[APPROVEDDATE]1-7. But this is giving me the date 7 calendar days from the Approve Date. I need it to give me 7 business days from the Approve Date.

 

Thanks!

Amy

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!