How can I sort dates in a column just by the day and month and NOT the year
if all three items are given in each cell? Example, I want to sort the
following dates so that all Jan dates are together, Feb dates are together
(and so on) with the DAYS of the month in order, NOT oldest/youngest by YEAR:
01/31/04...01/02/05...01/25/98...04/22/68...

The list should give me 01/02/05, 01/25/98, 01/31/04, 04/22/68.

Make sense? Maybe I need to re-format the date column to something else???

Thanks.
--
smags

You need to create a help column, if the dates are in A2:A100, insert a help
column B and use

=DATE(1,MONTH(A2),DAY(A2))

copy down


select the columns and sort by B ascending
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"smags" wrote in message
...
How can I sort dates in a column just by the day and month and NOT the
year
if all three items are given in each cell? Example, I want to sort the
following dates so that all Jan dates are together, Feb dates are together
(and so on) with the DAYS of the month in order, NOT oldest/youngest by
YEAR:
01/31/04...01/02/05...01/25/98...04/22/68...

The list should give me 01/02/05, 01/25/98, 01/31/04, 04/22/68.

Make sense? Maybe I need to re-format the date column to something
else???

Thanks.
--
smags