Create a helper column with a formula of
=TEXT(A1,"mmdd")
and sort by the helper column
--
HTH
Bob Phillips
"Debgala" <[email protected]> wrote in message
news:[email protected]...
> I have a report exported to XL as text file and converted to XL. The
dates
> appear as mm/dd/yy. I want to sort the dates by month & day, but want to
> ignore the year. Is this possible? How?
> Thanks,
Bookmarks