Join Dennis Taylor for an in-depth discussion in this video NETWORKDAYS: Calculating working days, part of Working with Dates and Times in Excel 2010.
Calculating differences between dates in Excel is often very straightforward.…It's simply a matter of subtracting information from two different cells.…So in Cell D4 here, we just simply want to find out the amount of time elapsed…from a starting date to an ending date here. Equal the later date minus the earlier date, 170 days.…So that tells us a lot.…But in a working environment sometimes we want to know the actual working days…between the two dates.…
So here's the same data here.…Here we want to use the function =NETWORKDAYS.…Now as I'm typing this, this is a long entry or longer than some. I see it right here.…So I'll just click on it. Press the tab key.…It pops into place. Starting date right here, comma, ending date.…For the moment, we'll ignore holidays.…It's not going to be 170.…This function will not count Saturdays and Sundays.…So our answer is 123, quite a bit pure than the 170 that we see over here.…
But we do have holidays involved here.…And of course, over this time period we've got let July 4th and Labor Day and Thanksgiving.…
- Understanding how Excel records and stores dates and times
- Looking at standard date/time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Exploring keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Rounding calculations
- Working with holidays
- Validating with dates
- Converting formatted dates to usable data
Skill Level Intermediate
Excel 2010: Financial Functions in Depthwith Curt Frye2h 18m Intermediate
Excel 2010: Advanced Formatting Techniqueswith Dennis Taylor3h 2m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Date/Time Functions
5. Calculating with Dates and Times
6. Using Dates and 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.