Use the WORKDAY function to calculate an end date, based on a starting date and the number of actual working days.
- [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 column A.…I'll simply drag this to the right for the moment.…
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.