Sort by Date Function

[Kat]

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.

 

[Duke Carey]

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)))

 

[Teethless mama]

Assume employee birthdates in column B
Create helper columns in C & D

In C2: =MONTH(B2)
In D2: =DAY(B2)
select both C2 & D2 copy down

Select column B,C, and D
Sort by column C, then Column D

 

[Gord Dibben]

Assuming dates are in column A.

In B1 enter =MONTH(A1) then double-click on fill handle of B1.

Sort on column B


Gord Dibben MS Excel MVP