Sorting Dates

[PRIMA]

Good day to All,

I have a table from Column A to F and I want them to be sorted out according to their dates. I am looking for a formulas or VBA which is sorting the whole Columns from A to F based on the dates from oldest to latest. The date format is dd-mmm-yy and it is in the Column F. By the way, I am using MS Excel 2010.

I tried to use the "Custom Sort" but it gives me the wrong arrangement. Any helps much appreciated.

Thank you in advance.

 

[Joe4]

I am not sure I follow. Can you provide a simple example so we can see exactly how you want this data sorted?
It almost sounds to me like a regular sort, where you sort all the data in multiple columns based on the entries in a single column, in which case you just highlight your whole sort range, and pick the column you wish to sort by.