| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
I think you'll have to make a new column, i.e., =year(a1) to get the year
out of your date. Then sort by that. ************ Anne Troy www.OfficeArticles.com "Winnie" wrote in message ... I try to sort the list of date by Month. But Excel only can sort by year. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
