Sorting Dates (month/day) in Excel (but ignoring year)

  • Thread starter Thread starter JAY KENT
  • Start date Start date
J

JAY KENT

I'm trying to sort a list of birthdays so that I can view
birthdays of the folks that work for me. Unfortunately
when I sort a date, it sorts first by year then by the
remainder of the date. I want my sort to ignore the
year. Even if I only put in the month and date, it adds a
year on its own.

Any thoughts?

Thanks.
 
You could try a formula in a helper column, eg:

=DATEDIF(,A1,"yd")

then copy it down & sort on that.

HTH,
Andy
 
Jay

With dates in Column A enter this in B1 and copy down.

=MONTH(A1)

Select Column B and Copy>Paste Special>Values

You can now sort by months, ignoring years.

Gord Dibben XL2002
 
Hey Gord.

Did you not try, or not like, or have a problem with the DATEDIF? I only ask
because, to the best of my knowledge, I made it up, syntactically, just by
tinkering. So if it has any issues I'd be interested.

Best rgds,
Andy
 
Andy,

I think it rocks, properly placing Feb 29th between Feb 28th and March 1st when
needed. There you go for the feedback. ;-)

Have a nice week-end!

Daniel M.
 
hi,

did you try to add a column with the formula TEXT(A2,"mm/dd") - Assumed
that birthday's located on "A" column).
and sort by that column.
 
Back
Top