View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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.