Sort By Date, Ignore Year

[SRBROTZ]

I have a need to sort a group of dates, ascending ignoring the year. the list

1/15/1960
1/06/1948
1/21/1980
1/1/1985

would be sorted as

1/1/1985
1/06/1948
1/15/1960
1/21/1980

Can any one help? What is needed to do this?

 

[Tom Ogilvy]

make a dummy column. Assume your first date is in A1

in row1 of the dummy column
=Date(2000,month(a1),day(a1))

copy this down and sort using this column as your key

I used a year of 2000 since it was a leap year.