When trying to work with unusually entered dates and times that you can't use in formulas, see how the DATEVALUE and TIMEVALUE functions let you convert data to usable content.
- When you get data from other sources,…sometimes you run into display issues…regarding dates and times.…And in order to deal with these,…you may have to rely upon…either the function datevalue or timevalue.…In cell A2 by the way, you might have noticed a triangle…in the upper left corner.…Anytime you see a green triangle, here's one example,…click on it, either to the right…or to the left of that cell.…You will see a yellow diamond with an exclamation point.…Slide over it, and you'll see a message.…This cell contains a date string represented…with only two digits for the year.…
I wouldn't call that an error,…but at least it draws to your attention the idea…that a two-digit year might not be what you want.…You might want a four-digit year.…We'll ignore that issue for the moment.…Let's say we use in cell B2 the function datevalue.…As I type that, look at the description below,…converts a date in the form of text…to a number that represents the date…in Microsoft Excel date time code.…When you do run into these date and time issues,…
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/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.