See how the NETWORKDAYS function lets you calculate the number of working days between a start and end date. This is handy for excluding weekends and holidays.
- [Instructor] Sometimes you need to calculate…the difference between two dates.…It's very simple and straightforward in Excel…if that's all you need.…In this worksheet called NETWORKDAYS,…we've got some information in column D here…indicating a starting date per project…and an ending date.…How long will the project be?…If it's simply a question of how many days will it take,…if we're a 24/7 operation possibly…or if we work every day in this environment,…we simply subtract the two.…Equal, a later date in this case, September 1st entry…minus the earlier date, the May 25th entry.…
How many days?…99 days.…But, let's say it's a five day week operation,…we don't want to count Saturdays and Sundays.…So, we use a function called NETWORKDAYS.…If you somehow saw this function in a list…you might assume it has something to do with networks.…Nothing at all there.…NETWORKDAYS, there it is right there, double-click.…Starting date in cell E2, comma,…the ending date here in cell E3.…Let's not count Saturdays and Sundays.…
That's what NETWORKDAYS does for us.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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.