Forum Discussion
dates in excel
Can someone help with converting these dates into a format that I can sort from most recent. Although I have tried some functions but none work. Thanks
Another way is to select first part of the column E (E2:E210), Data->Text to Columns and on the third step of the wizard select dates and DMY. Repeat the same for the rest (starting from E211) but apply YMD. And that apply date format to entire column E.