Formula for business days

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

Find more posts tagged with

Formulas

Comments

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! 🤣

Sign in to join the conversation!

Quick Links

Trending discussions

Help with automation to find bad formatting
I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries…
Please help to convert this Excel formula to a usable Smartsheet formula
Hi my colleague has imported an Excel spreadsheet and one of the formulas hasn't worked on import. Please could someone let me know if the following Excel formula can be converted into a usable Smartsheet formula? Here it is: =IF(B4<>"", ROW()-1, "") Many thanks, Lee
Getting Unparseable error using IF function
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…