| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sort month dates
I have a column of many dates in this format, sorted by day/month/year:
December 16, 1900 January 22, 1901 April 14, 1902 July 9, 1903 I would like to sort the dates by month and day and ignore year so the above data would show as: January 22, 1901 April 14, 1902 July 9, 1903 December 16, 1900 I will appreciate advice. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sort month dates
Try a helper column =TEXT(A1,"mm/dd") and sort by that column.
-- David Biddulph "Robert Judge" wrote in message ... I have a column of many dates in this format, sorted by day/month/year: December 16, 1900 January 22, 1901 April 14, 1902 July 9, 1903 I would like to sort the dates by month and day and ignore year so the above data would show as: January 22, 1901 April 14, 1902 July 9, 1903 December 16, 1900 I will appreciate advice. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sort month dates
Try a helper column =TEXT(A1,"mm/dd") and sort by that column.
-- David Biddulph "Robert Judge" wrote in message ... I have a column of many dates in this format, sorted by day/month/year: December 16, 1900 January 22, 1901 April 14, 1902 July 9, 1903 I would like to sort the dates by month and day and ignore year so the above data would show as: January 22, 1901 April 14, 1902 July 9, 1903 December 16, 1900 I will appreciate advice. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sort month dates
Thanks. One more question, please. I now want to convert the result
produced by the formula so that I can import it into another program. I believe there is some EXCEL function so that the result will become fixed text. I think it is the EXCEL function VALUE, but I cannot remember. So, to repeat, what I now want to do is convert the result produced by the "helper column" to an absolute value of that formula. I hope my question is clear, and I will appreciate further advice. "David Biddulph" wrote: Try a helper column =TEXT(A1,"mm/dd") and sort by that column. -- David Biddulph "Robert Judge" wrote in message ... I have a column of many dates in this format, sorted by day/month/year: December 16, 1900 January 22, 1901 April 14, 1902 July 9, 1903 I would like to sort the dates by month and day and ignore year so the above data would show as: January 22, 1901 April 14, 1902 July 9, 1903 December 16, 1900 I will appreciate advice. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sort month dates
Copy, then Edit/ Paste Special: Values
-- David Biddulph "Robert Judge" wrote in message ... Thanks. One more question, please. I now want to convert the result produced by the formula so that I can import it into another program. I believe there is some EXCEL function so that the result will become fixed text. I think it is the EXCEL function VALUE, but I cannot remember. So, to repeat, what I now want to do is convert the result produced by the "helper column" to an absolute value of that formula. I hope my question is clear, and I will appreciate further advice. "David Biddulph" wrote: Try a helper column =TEXT(A1,"mm/dd") and sort by that column. -- David Biddulph "Robert Judge" wrote in message ... I have a column of many dates in this format, sorted by day/month/year: December 16, 1900 January 22, 1901 April 14, 1902 July 9, 1903 I would like to sort the dates by month and day and ignore year so the above data would show as: January 22, 1901 April 14, 1902 July 9, 1903 December 16, 1900 I will appreciate advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates Formatting Question - What if you do not know month and/or d | Excel Discussion (Misc queries) | |||
| How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)? | Excel Worksheet Functions | |||
| calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
| How do I sort dates in Excel | Excel Discussion (Misc queries) | |||
| sort dates by month and day not year | Excel Worksheet Functions | |||
Linear Mode
