Create a helper column with a formula of

=TEXT(A1,"mmdd")

and sort by the helper column

--
HTH

Bob Phillips

"Debgala" wrote in message
...
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,