MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SORTING THE MONTH


Posted by liz on December 16, 2001 4:22 AM

I have a Column that stores the "date of birth", I want to sort these dates by Month how can I do this?


Posted by Aladin Akyurek on December 16, 2001 5:59 AM

Liz --

One way:

Insert a column after the column with the birth dates.

In the first empty cell corresponding to the first birth date enter

=MONTH(A2) [ dubble click on the little black square of this cell in order to copy it for all birth dates ]

where A2 contains the first birth date [adjust to your situation].

Sort the target data on months column.

Aladin

========