How to sort if you have this type of dates format to ascending or descending

For example: Wednesday 03 Mar 2010

You need to highlight column A —> right click –>select Format Cells

Go to Format Cells



Type in dddd dd mmm yyyy

ddd will show Mon

dddd will show Monday- Sunday

dd will show date eg: 23

mmm will show Mar  and if you put mmmm will appear as March

yy will show 11 and yyyy will appear as 2011

Another example

1) If you custom Format Cells using dddd dd/mmm/yyyy

You will get Wednesday 03/Mar/2010

2) If you custom Format Cells using dddd dd-mmm-yyyy

You will get Wednesday 03-Mar-2010

3) ddd dd-mmm-yyyy

You will get Wed 03-Mar-2010

4) ddd dd mmm

You will get Wed 03 Mar

Now i want these dates to appear descending from Z to A

And if i want it to appear as ascending

If i remove the year in the custom format as ddd dd mmm

It will appear as this Fri 06 Mar