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...
Alternatively add a helper column with
=VALUE(MID(SUBSTITUTE(B1:B3,".",""),4,18))where B1:B3 is the column with those dates in it
Then use this helper column to sort or do calculations with.