Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula that only counts business days

Ian Staley

Ian Staley ✭

07/21/16 edited 12/09/19 in Archived 2016 Posts

Hello,

I'm trying to write a formula for a date that will say something like "due in 18 business days".

So basically " =[column name] + 18" but exclude weedend days. Is that possible?

Thanks so much!

Tags:

Formulas

0 ·

Comments

Brett Evans ✭✭✭✭✭✭

07/21/16 edited 07/21/16

This.
="Due in " + NETWORKDAYS(TODAY(), [ColumnWithDate]1) + " business days."

0 · Share on Facebook Share on Twitter
Ian Staley ✭

07/22/16 edited 07/22/16

Thank you very much!!!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Multiple Approvers on one Approval Automation?
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can move forward. To count when the responses are all in, I am moving the entry to a new sheet and counting the references that…
Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…