Unable to sort dates in column correctly

Hi all,
I'm having a lot of problem sorting the dates in column A either in descending or ascending order in my excel worksheet and unable to find a solution. The problem with the dates is that it is arrange as ddd yyyy/mm/dd, eg Mon 2014 Dec 12. When I use the sort function it runs according to the day - ddd (first alphabet). eg:

In Ascending order:
Thu 2014 Dec 12
Thu 2014 Dec 18
Tue 2014 Dec 10
Wed 2014 Dec 11

Want I need is that the dates arrange in sequence from either newest to the oldest but it work that way in the excel sort function.

I thought of splitting the dates using texttocolumn function to sort but then I have data in the other columns , so it will over ride the data and there is also the headers on the first roll of each columns. After doing that, I will need to delete those "date" columns and retain the original column A.

Can anyone help??

Thanks upfront.

Hi Mumps1,
Sorry for the late reply, been working like mad.

As you can see from my previous post

Wed 2014 Dec 11 should be on top of the list of dates but its at the bottom b'cos it follows the first alphabet of the ddd

Thanks

Hi Mumps1

I just uploaded a draft copy of my dates problem. As you can see Jan 14 isn't on the top of the date column but it sort according to the first alphabet of the day, which is Fri followed by Thu and Wed. I want it to be sort either the latest or oldest, which is

Tue 2014 Jan 14
Thu 2014 Jan 16
Wed 2014 Feb 20
Fri 2014 Mar 12
Wed 2014 May 13

Please help

Hi
As Mumps1 mentioned, your data was being treated as text since it was not formatted or entered as dates.

If you have an large list of such data, re-typing them as valid dates would be onerous.

Here is a macro that can convert them to valid Excel dates.
Select your range of dates (ex. A2:A5 in your example) and then run the macro.

Notes:
1. Work on a copy of your file as this replaces the selected text. In case something were to go amiss, you would still have the original.
2. Each new date will look like this: 'Sat 2014-Dec-13'; you can change the format in Excel or modify the 3nd last line in the macro as needed.
The results data will now be sorted as dates as you wish.
3. The macro's code is not the most efficient method but it shows the steps for converting your text into date values.
Another version could look for the separating spacings to decode the year, month, day etc.
This version assumes each original data has the same layout. ddd yyyy mmm dd

Please Login or Register  to view this content.

Hope this helps a bit.
- Stu

Thanks Mumps1.

It works. But the data and dates were given by the employee, so I consolidate them in a master copy, which is the reason why I need to sort all those dates with the data.