Sort By Date, Ignore Year
 

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?

Sort By Date, Ignore Year
 

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.

--
Regards,
Tom Ogilvy



SRBROTZ wrote in message
m...
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?