Evening all,
I've a client who has entered all his time sheet data in columns:
Date - Ref - Description - Time - Miles - etc...
Each row is a new timesheet data entry

"Someone" sorted and saved the spreadsheet, some time ago - and it had only sorted by day, so 21.02.16 is next to 21.10.16, etc..
The date is UK dd.mm.yy - they need it such that it is sorted by "actual" date: 21.02.16 is next to 22.02.16, 23.02.16, etc..

Anyone have a clue as to how this might be achieved?

I searched the threads and web for a couple of hours and have found no solution - can any of the amazing Excel people here help?

Many thanks