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

Options

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
Options
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
Options
Thank you very much!!!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How to count unchecked boxes for rows with data only
I tried this formula but it's also counting the unchecked rows without data =COUNTIFS([Client Lost?]:[Client Lost?], 0) What should be the correct formula?
Risk Rating Formula
Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those selections I want to have a 3rd column which is the output of the formula, Rating, designated High, Medium, Low. Below are the…
Trouble Reaching Smartsheet - errorCode: 63
Hello all - We have a sheet that is refusing to save. Each time we try, we receive the following message. Anyone have any ideas on how to resolve this? Thank you!