Ensure the cells are actually formatted dd/mm/yy, then sort by date,
ascending (or descending if you choose). Your months will be grouped
correctly.

Works for me, I have xl2003.
--
John C


"Roy Gudgeon" wrote:

me again....

I have a spreadsheet that contains dates written in the following format:

dd/mm/yy

I want to be able to sort by month, then day within the month, currently
sort is by day and I therefore have a result that mixes the months.

any advice ?
--
thanks
Roy