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
From the course: Excel 2016: Working with Dates and Times
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
EOMONTH and EDATE – tabulating end of months and future/past dates4m 31s
-
DATEDIF – tabulating date differences by year, month, and day6m 50s
-
WEEKDAY – determining the day of the week3m 7s
-
WEEKNUM and ISOWEEKNUM – calculating week numbers2m 41s
-
NETWORKDAYS – calculating working days3m 5s
-
WORKDAY – calculating ending date1m 51s
-
DATEVALUE and TIMEVALUE – converting text entries into dates and times2m 46s
-
-
-
-