Insert a new column next to the actual birthdays - let's say they are in
column B, and you insert a new column C, and assume the dates commence in row
2. Use this formula in the new column C, row 2, then copy it down as needed,
then sort on the new column

=date(year(today()),month(b2),day(b2))

However, that may generate birthdays in 2007 but earlier than today, so you
may want to use

=if(date(year(today()),month(b2),day(b2))<today(), date(year(today())+1,month(b2),day(b2)),date(year( today()),month(b2),day(b2)))






"Kat" wrote:

I want to sort a list of employees birthdates but I only want to sort them by
month then date not year. When I do a sort function it will sort by the
year. Does anyone know how to have it sort the other way.