Formula for business days

aelmore

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

Mike Wilday

=Workday(Approvedate]1, -7) should do the trick

See here for more on the workday function. 

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

A Rose

Thank you @Mike Wilday this actually helped me! 🤩

Mike Wilday

Awesome! Glad it helped!!! And so many years later! 🤣