Join Dennis Taylor for an in-depth discussion in this video Understanding how Excel records and stores dates, part of Excel 2007: Working with Dates and Times.
In many Excel worksheets, date data and time data are important ingredients.…For example, on the screen here, in column F, we see Hire Dates, important…information for this list here.…In another worksheet here, we're keeping track of sales by date and time; both…columns C and D are important.…Notice that in both cases the information is right aligned.…The way Excels handles dates and times is perhaps best understood by talking…about the idea that both of them are considered values.…
If you type a date into a cell, for example, 4/5/12, April 5th 2012, the…information is right aligned.…If you type in a date that really doesn't exist, probably a typo, for example,…November 31st, slash 12,…that's left aligned. As far as Excel is concerned, that's just string of characters.…When we put in valid dates, Excel automatically aligns them on the right side,…as it does with values in general throughout Excel; put in a value,…it's right aligned.…
Text entry is left aligned.…Of course, you can change that, but, because it's right aligned it alerts us…
- 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 2007: Creating Business Budgetswith Curt Frye1h 3m Intermediate
Excel 2007: Introduction to Formulas and Functionswith Curt Frye2h 26m 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.