Sort dates dd.mm.yy by year

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



-----Original Message-----
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


---
Message posted from http://www.ExcelForum.com/

.

sorry, includes column A in highlighting the columns.


aboiy

Hi Hayley,

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

aboiy

hayley wrote in message ...
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.




---
Message posted from http://www.ExcelForum.com/