How to add workingdays?

HBL

HBL ✭✭

01/26/23 in Formulas and Functions

Looking to add working days to a Date cell.

For example, 1/26/23 + 5 working days =2/2/23.

Is there a way to do this?

The only formula I see is for Networkdays but requires two dates to calc.

Thanks,

Huy

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

01/26/23

Take a look at the WORKDAY function:
https://help.smartsheet.com/function/workday

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula in Smartsheet that will tell me if the data in 4 different columns is the same
I am looking for a formula in smartsheet that will tell me if the data in 4 different columns is the same. In excel I am able to use =COUNTIF(A3:D3,A3)=4 In Smartsheet I am getting "INVALID COUMN VALUE"
Formula to summarize data from symbols column for same row ID
This discussion was created from comments split from: Countifs formula with and/or criteria across multiple columns.
Formula to count active projects if dates are not equal?
For project tracking we have an original end date and an actual end date. At the beginning of a project the dates would be equal, if there is slippage and the date is different we would update actual end date to the new end date. We have a dashboard with a widget that shows the count of projects where the end date changed.…