Join Dennis Taylor for an in-depth discussion in this video Calculating date differences across days, months, and years, part of Excel 2007: Working with Dates and Times.
Calculating date differences in Excel is generally straightforward, whether you…are talking about existing dates or looking into the future.…In columns A and B, we are tracking some equipment, when it was installed,…when the expiration date actually occurred.…We want to tabulate how many days elapsed in each case.…Simple formula, equal, the cell that contains the later date, minus the cell…containing the earlier date.…And the answer will be in days, 1,524.…
Double-click will copy this down the column.…We have our answers for every single case here,…and whether it's within the same year, or crosses yearly boundaries, or…century boundaries.…And of course, this can work well into the future, easily capturing the…difference between days.…If you need to tabulate years, you probably want to take a look at the datediv function.…This is simply for calculating days by subtracting.…At other times, you have situations where you want to set a future date, or…possibly a date in the past as well, but in the example in column E here, we…
- 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.