Any Excel guru here?

[Cheekykid]

How can I sort out a column in terms of dates? from the oldest to the newest. My dates are in the format of: 12/05/07 etc. Thanks

 

[Cheekykid]

As long as its formatted to DATE then you can sort it via descending.

Ok thanks


Because I have names and stuff next to the dates how can i sort them by date but with the details of each date to not get messed up in terms of being next to the right information

 

[Cheekykid]

highlight all the data rows and columns, choose data and sort, change sort by to the column which contains the list of dates.

It does sort them but by date not by month . How can i make it take into account both of them?