Sort By Date, Ignore Year

  • Thread starter Thread starter SRBROTZ
  • Start date Start date
S

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?
 
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.
 
Back
Top