Forum Discussion
Sorting dates in Excel from oldest to newest is not working
Hi all, I would like to sort a date series in Excel, formatted as Mon Feb. 10, 2025 08:59 AM, from oldest to newest, but I can’t get it to work. Every week, I have to download a list from a program...
I'm guessing you are opening a CSV file. Don't open that csv file directly. Instead, save it. Then go to Excel and click Data, Get Data, From File, From text/CSV.
Select that date column and select split column by delimiter. Choose space and select to split only by the first delimiter. This splits it into a column with just the day and a column with the remainder of the date. You can delete the day column now. If you're in luck, power query will then recognize the dates already.