| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting Dates
How can I sort dates by the month instead of the year?
|
|
#2
|
|||
|
|||
|
Insert a helper column near the column of dates. Say you inserted in column
B. Enter =Month(A1) in the helper cell (if the date is in A1). Then copy down. Finally sort by the helper column. Have a good day -- Gary's Student " wrote: How can I sort dates by the month instead of the year? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Dates | Excel Worksheet Functions | |||
| Sorting Dates in Days of the Week | Excel Discussion (Misc queries) | |||
| Sorting dates | Excel Worksheet Functions | |||
| Question on sorting dates | Excel Discussion (Misc queries) | |||
| Sorting dates | Excel Worksheet Functions | |||
Linear Mode
