Working Days

C. Srinidhi Ragunathan

Greetings,

I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)?

 

Thank you

Paul Newcome

I would take a look at the WORKDAY function.

 

WORKDAY()    

WORKDAY(date, num_days, [holidays])    

Used in a Date column to return a date from a specified number of working days. Optionally excludes holidays outlined in a range.

Mike Wilday

Hmmm. You might also try turning on dependencies. It will set up a start time and a finish time column if you don't already have one and calculate the finish time for you. When you edit the start date or the duration, the end date will calculate for you automatically. 

• https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
• https://www.techrepublic.com/article/how-to-set-up-projects-in-smartsheet/

That might be a better way of doing it rather than using custom formulas. 

Mike Wilday

Another added benefit of turning on dependencies is that you can also make the end of one task determine the beginning of the next one. 

C. Srinidhi Ragunathan

Thank you very much. 

It worked!

Paul Newcome

Happy to help! 

 

I would also suggest looking into dependencies as Mike suggested below. I don't use them for various reasons, so I never think about them as a solution.

Bryan Mac

Can this be done without using a function?