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