Handling Dates with unusual formats

- 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.…