sort date

  • Thread starter Thread starter sksk4798
  • Start date Start date
S

sksk4798

I have date range in Col A with the format say 24.01.2009 i.e.24th Jan
2009,20.03.2009, 19.02.2009,17.02.2009,16.03.2009 and so on. While I want to
sort the dates in whole range according the ascending order, it is sorted
like this:
24.01.2009
16.03.2009
17.02.2009
19.02.2009
20.03.2009
So the sorting is not done date wise. Any body can help me?
 
In B1 enter:
=DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) and copy down
then sort cols A & B by B to display:

24.01.2009 1/24/2009
17.02.2009 2/17/2009
19.02.2009 2/19/2009
16.03.2009 3/16/2009
20.03.2009 3/20/2009
 
Select the data.

Data>Text to Columns>Next>Next>Column Data Format>DMY and Finish.


Gord Dibben MS Excel MVP
 
Back
Top