| 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. |
| 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 | |||
Threaded Mode
