| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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, |
|
#2
|
|||
|
|||
|
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, |
|
#3
|
|||
|
|||
|
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, |
|
#4
|
|||
|
|||
|
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, |
|
#5
|
|||
|
|||
|
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, |
|
#6
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort dates by day then month, not by year. | Excel Worksheet Functions | |||
| sort dates by month and day not year | Excel Worksheet Functions | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
Linear Mode
