Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
I try to sort the list of date by Month. But Excel only can sort by
year. One way is to use a "helper" column. In the first row of an unused column, put =MONTH(A1) (assuming column A holds dates) and copy down. Then select all columns of interest, including the helper, and sort by the helper column first. The helper can be hidden if necessary. (I used "DAY" a minute ago, but should've used "MONTH.") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help needed with date format | Excel Discussion (Misc queries) | |||
Sorting data by date | Excel Worksheet Functions | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
How do I format the date in a footer to display the month in lett. | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions |