Sort dates dd.mm.yy by year

[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

 

[Jason Morin]

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

 

[aboiy]

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

 

[aboiy]

sorry, includes column A in highlighting the columns.


aboiy

 

[aboiy]

Hi Hayley,

I mean to include column A in sorting but not in copying
formula.

aboiy

 

[2rrs]

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

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