Sort by Date Function
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
"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.
|