Sorting dates

[Herb]

I want to sort dates by month and day while ignoring the year. Is there a
way to do that? Thanks. -Herb Mann

7/1/2005
9/1/2003
12/15/2004

 

[Peo Sjoblom]

Only by using a help column and sort by that column

=MONTH(A2)

assuming your data starts in A2, copy down and sort

--
Regards,

Peo Sjoblom

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

 

[Frank Kabel]

Hi
in a helper column enter the formula
=TEXT(A1,"MMDD")
and sort with this helper column

 

[Herb]

Thank you very much.

Hi
in a helper column enter the formula
=TEXT(A1,"MMDD")
and sort with this helper column