From the course: Excel 2016: Working with Dates and Times

Unlock the full course today

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

WORKDAY – calculating ending date

WORKDAY – calculating ending date

From the course: Excel 2016: Working with Dates and Times

Start my 1-month free trial

WORKDAY – calculating ending date

- [Instructor] On this worksheet called WORKDAY, we'd like to calculate when a project will end. And you might think of it as the reverse of the previous function that we talked about called Net Work Days. In column D we've got a project starting May 25th, 120 days long. If it is a seven day a week operation, we don't even need a special function. Equal, a starting date, plus the project length. We have an answer, it will end on September 22nd. But let's say we only want to count Mondays through Fridays, just working days. The function is workday. And it also has an international variation, as does net work days, which you might have seen in the previous movie. Workday, here's our starting date. Comma. This is how many days long. Let's not count those Saturdays and Sundays. So instead of ending on September 22nd, and for the moment we're ignoring holidays, this project will end on November 9th. But there certainly will be some holidays involved, and we've got our holiday list there in…

Contents