Hello Excel Friends,

I've been searching and trying to figure this out in Excel all day, and I just can't get what I need! So I hope you guys can help me figure it out.

Basically, I've got a column with a date, but it's not in a typical date format. I need a line in my macro to convert this to a typical date format so I can sort oldest to newest.

I've attached a sheet with "CURRENT" and "DESIRED" formats. Any help would be much appreciated, as I've got 100k+ columns to convert!

date.xlsx

THANKS!!