Forum Discussion
How to sort column (of character strings starting with MMDDYY) by date?
Hello everyone, I'm sure there's an efficient way to do this but I'm stumped, so I turn to the experts. I have a spreadsheet where one of the columns is filled with character strings that be...
ElJarrodthe way I look at it, if you could switch the date format to YYMMDD it should helps. Reason being the sorting methology usually works that way vs MMDDYY (alternatively you could use DDMMYY but I hardly think it works as well as YYMMDD)
The moment you do that, you can sort.. see screen shot below.