Join Dennis Taylor for an in-depth discussion in this video Calculating date differences across days, months, and years, part of Working with Dates and Times in Excel 2010.
Calculating days elapsed between two dates or calculating days into the future…is generally pretty straightforward in Excel.…Counting dates elapsed is a simple subtraction. Equal the later date.…The example here, B2 minus the earlier date.…How many days have passed?…The unit of time is one equal day.…If we come up with an answer like this, simply format it. A couple of ways.…Ctrl+Shift+Tilde is one way.…You can also on the Home tab use the comma button if you wish.…
This does introduce decimals however. You can hide those if you wish.…So a couple of different ways to quickly format this.…Of course, by double-clicking here we could copy these down the column.…Here and there, we see sometimes we're within the same year.…This crosses yearly boundaries with no difficulty whatsoever, and of course…century boundaries as well.…It's an accurate count to the day, how many days between these two days.…Sometimes we need to look into the future.…In the example here, we want to know 90 days from this 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
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.