sort dates
 

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,

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,

Hi Deb,
Create a helper column, use the fill handle to copy down a formula like:
=Date(0,Month(a1), 1)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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,

Good, and a lot less confusing than my answer would be to someone
looking at the helper column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

Thank you Bob. This was just the formula I needed!
Deb

"Bob Phillips" wrote:

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,

Thank you David, both for your own solution, and for your recommending I use
Bob's. I'd tried a lot of stuff in a helper column - to no avail until now!
Thanks,
Deb

Hi Deb,
Create a helper column, use the fill handle to copy down a formula like:
=Date(0,Month(a1), 1)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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,