Working Days

C. Srinidhi Ragunathan · 08/12/19

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 · 08/12/19

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 · 08/12/19

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.

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

Mike Wilday · 08/12/19

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 · 08/12/19

Thank you very much.

It worked!

Paul Newcome · 08/13/19

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 · 10/07/22

Can this be done without using a function?

Working Days

Comments

Categories