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

On Thu, 30 Aug 2007 09:16:06 -0700, 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.