Microsoft Excel Won’t Sort Dates Correctly – a Solution

I was having an awful time getting dates to sort properly even after changing the format to the date format. Turns out there is another step to take. I have this queued to the solution, but feel free to backup to see the whole thing.