If you're saying that you want to sort by month and day, regardless of the
year, then you may be better off producing a helper column and sorting by
that. If your dates of birth are in A1, then try
=DATE(2008,MONTH(A1),DAY(A1)) and sort by that. Otherwise you could have
two helper columns MONTH(A1) and DAY(A1) and sort by those two columns in
that order.
--
David Biddulph

"T." wrote in message
...
Hi

I am trying to set up a list of all my friends birthdays in Excel and then
trying to get Excel to sort them into date order ( so that I can just
follow
them through the year - rather than them being in no logical order.)

However I just cant get the formula right to do it.

I am using the date format of dd/mm/yyyy (the British version)

I am using Excel 2007.

Any help is much apreciated.

T.