From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Determining a completion date with the WORKDAY function

Determining a completion date with the WORKDAY function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Determining a completion date with the WORKDAY function

“

- On this worksheet called WORKDAY, we've got some projects listed by their starting date in Column C, the length of the project in days is listed here in Column D. If this were a seven-day a week operation, if we wanted to know when this project ends, we'll simply add 60 onto November 2nd. Example, equal the starting date plus 60 and we have an answer, January 1st. Now, more common is the idea, in a working environment, there are only five days, maybe six. So, to get an actual count here and not include the weekends, equal workday. This function is analogous to networkdays. You might say this is working the opposite direction, and this too has an option for calculating our answers here based on different weekends. So we start with workday, left parenthesis, our starting date in C2, comma, the length of this project, it's in D2, so in effect, we're about to add 60, but this time, we will not be counting Saturdays and Sundays. Simply press Enter. And when you get an answer like this…

Contents