Sorting Dates

  • Thread starter Thread starter Ket.Kana
  • Start date Start date
K

Ket.Kana

I have a small spreadsheet which contains employees names and dates of
birth. ie column A=DOB, column B = First Name, column C = Lastname. Is it
possible to sort this list by date order?
Currently, by choosing Data -> Sort, I have an option of sorting by date
which is sorted year first. What I need is to sort the list so that it is
sorted by month first, then year.
This way I can see all the January, then February etc etc.
I am using Windows 2K and Office 2K.
I'm sure there must be a simple solution but I am going round in circles.

Any help greatly appreciated.

Regards,

Ket
(Cold and windy London,UK)
 
Ket,

Insert two new columns (say column D & E)
In column D "year of birth": =year(A1)
In column E "month of birth":=month(A1)
'You could also use a day column if you wanted'

Copy down the formulas and sort by month and year.

Regards,
Felipe
 
Add a new column called Month. In it, put =TEXT
(A2,"mmmm"). The number of Ms will determine the
appearance. For February, for example, you'd get the
following:
m 2
mm 02
mmm Feb
mmmm February

If you choose a word, be sure to go into options in your
sort and change the sort order as appropriate, otherwise
it will sort alphabetically.

Jane
 
Back
Top