Thread: Sorting dates
View Single Post
  #4   Report Post  
Old October 30th 04, 01:22 AM
Herb
 
Posts: n/a
Default

Thank you very much.

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

--
Regards
Frank Kabel
Frankfurt, Germany


Herb wrote:
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