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" <Debgala@discussions.microsoft.com> wrote in message
news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> 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" <Debgala@discussions.microsoft.com> wrote in message
news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message news:Og5xkJDnFHA.3572@TK2MSFTNGP09.phx.gbl...
> Create a helper column with a formula of
>
> =TEXT(A1,"mmdd")
>
> and sort by the helper column
>
> --
> HTH
>
> Bob Phillips
>
> "Debgala" <Debgala@discussions.microsoft.com> wrote in message
> news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > 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" <bob.phillips@notheretiscali.co.uk> wrote in message news:Og5xkJDnFHA.3572@TK2MSFTNGP09.phx.gbl...
> Create a helper column with a formula of
>
> =TEXT(A1,"mmdd")
>
> and sort by the helper column
>
> --
> HTH
>
> Bob Phillips
>
> "Debgala" <Debgala@discussions.microsoft.com> wrote in message
> news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > 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" <Debgala@discussions.microsoft.com> wrote in message
> news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > 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" <Debgala@discussions.microsoft.com> wrote in message
> news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > 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" <Debgala@discussions.microsoft.com> wrote in message news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> 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" <Debgala@discussions.microsoft.com> wrote in message news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> 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" <Debgala@discussions.microsoft.com> wrote in message news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > 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" <Debgala@discussions.microsoft.com> wrote in message news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > 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,
>
>
>