Join Dennis Taylor for an in-depth discussion in this video NETWORKDAYS: Calculating working days, part of Excel 2007: Working with Dates and Times.
As you work with dates in Excel, it becomes useful and very helpful at times to…understand how much time has elapsed between a starting and an ending date, and…whether it has to do with a project or an anniversary.…It's easy and straightforward in Excel to subtract cells that have dates to…figure out the amount of days elapsed.…Equal, the later date, in this case D3, December 2, minus the starting date, in…this particular example, June 15. 170 days.…
That's certainly useful information.…But in a working environment, many times you would like to be calculating the…number of working days.…We don't want to count the weekends.…So in cell E4 here, working with the same dates, let's use the…function networkdays.…The starting date, June 15, comes first, comma, the ending date, and for the…moment we will ignore the holidays, but we do want know how much time has…elapsed between the two dates, not counting the weekends.…
And instead of 170, it's considerably shorter: 123.…It's important to note here that this is counting both the starting date and the ending date.…
- 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
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Excel's 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.