Join Dennis Taylor for an in-depth discussion in this video How Excel records and stores dates, part of Excel 2013: Working with Dates and Times.
…One of Excel's strongest features is its ability to handle dates and times.…In this worksheet called dates, we've got dates in column…B representing hire dates for the employees in column A.…And with a different set of data over in columns J, K, and L, we've…got date of sale based on various units…sold by different sales persons within the organization.…In both examples, the dates being stored here…are potentially useful in a variety of ways.…And if you enter dates in a standard way, which is covered in…a later course, you'll see that what actually you're storing there is a value.…
Excel treats dates as values.…If you make a standard date entry, suppose it's, for example, May…6th of the year 2014, and you might type it this way.…Notice that the information is being stored in the right side of the cell.…And that's what Excel does when it handles numbers.…So if you talk about just a pure number, that ends up on the right side.…That perhaps is a clue to the fact that each date is actually a value.…Now, although it's not terribly important much of the time.…
- Understanding how Excel records and stores dates and times
- Looking at standard date and time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Using keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Calculating the day of the week
- Working with holidays
- Validating dates
- Converting formatted dates to usable data
Skill Level Intermediate
1. The Excel Date and Time Systems
2. Creating Date and Time Entries
Instant date and time entry1m 28s
3. Date and Time Formatting
4. Date and 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.