Join Dennis Taylor for an in-depth discussion in this video Handling Dates with unusual formats, part of Excel Tips Weekly.
- When you get data from other sources,…sometimes the way dates are entered are a bit unusual.…In column A, we're seeing some…data entries here, not typical.…In columns B, C, and D, we're putting in entries…that could be interpretations of how that data…really should have been entered.…Now, it's highly unlikely, with certain…sets of data, would you ever have data…covering the year 2011 and also the year 1920.…But as you look at the numbers,…you could see how that could be derived;…1920, the year 1920, is the middle four digits here.…
And there's a 12 in front of it.…There's an 11 on the end of it.…So it could be interpreted as December 11th…of that year or November 12th of that year.…We see some other entries here…and how they might be interpreted.…And, down here in rows nine, 10, and 11,…we're looking at recent dates;…2011, but even there, we can see…two different interpretations of the same data.…This entry down here actually has…three different interpretations.…Is that from the year 2020?…That's where the year is in the middle of the data.…
Skill Level Appropriate for all
Excel Tips - New This Week
- 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.