Sort dates dd.mm.yy by year

  • Thread starter Thread starter hayley
  • Start date Start date
H

hayley

Hi there

I am trying to sort a set of dates by year. The format is for example:
01.06.95
02.06.03
15.06.01
05.06.02

When I sort it sorts them by the first day of the month but I want i
to sort by year first. I can't see a way round this at the moment. An
ideas would be appreciated.

Many thanks

Hayle
 
You can sort by extracting the year to another col. using:

=RIGHT(A1,2)

and then select both columns and sort on this new column.

HTH
Jason
Atlanta, GA
 
Hi Hayley,

Try also this tips i got from the groups before;

You'll need a helper column. with your dates in column A
put the formula in column B, C, D.
A B C D
01.06.95 =day(A1) =month(A1) =year(A1)
02.06.03
15.06.01
05.06.02

Highlight "B1", "C1", "D1", you'll see a fill handle
appear in lower right corner of D1, drag it to copy down
the formula.

Then start sorting starting from column D, then by C & D.

Hope that helps.

aboiy
 
hayley said:
Hi there

I am trying to sort a set of dates by year. The format is for example:
01.06.95
02.06.03
15.06.01
05.06.02

When I sort it sorts them by the first day of the month but I want it
to sort by year first. I can't see a way round this at the moment. Any
ideas would be appreciated.

Many thanks

Hayley
Click to expand...

Try this: =TEXT(A1,"yyyymmdd")which sorts by year, month and day.
 
Back
Top