| Home |
| Search |
| Today's Posts |
|
#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, |
| 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) | |||
Threaded Mode
