Introduction to converting dates to valid Excel dates
In this module of the Data Cleanup Course you will learn how to handle dates in any format and make sure Excel sees and uses them as dates.
So if your dates look like any of these below (and any other types) and for some reason it doesn’t format or refuses to act like a date, then you need to learn these tips and tricks.
You will learn about tools and formula that will allow you to convert dates in any format, to a valid date in Excel that you can format, sort, filter on, graph and more.