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

Calculating Critical Open Items per Business Analyst
I am trying to calculate how many Open items a business analyst has that are in the critical category, this is the formula i am trying to use but i must be doing something wrong Open equals = To Do, In Progress, Daily Task =COUNTIFS({2025 Team Activity Tracker Range 3}, HAS(@cell, "BA NAME"), {2025 Team Activity Tracker…
Updating dates to build a project plan
I am a complete newbie so please bare with me. I am creating a project plan with a target submission date. We have a guideline how much time should each task take. Is there a way that dates populate automatically when you are planning backwards? I cannot believe I need to calculate each ask and enter start and and date…
PMO Template
I am struggling with the PMO template and the Schedule Health column in the Project Plan, which is indicating 'Red' even after a Task is complete, with this formula. =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) Could I use a formula to ask it only to count if "Status" is…