| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sorting date " MMM-YY" (Jan-05)
Hi,
I have a spreadsheets with ticket numbers and the date it was submitted. It is in medium date format (3/18/2005). I have used this formula: =text(A2,"MMM-YY") to conver it to Mar-05. now i have a column with MMMYYY date, however, it will not let me sort it. It is sorting alphabetically, and not in the order of the date. so I have Feb-04,Feb-05, Jan-04,Jan-05 and so on. How can I sort this by month then year? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| sorting data by date | Excel Worksheet Functions | |||
| Sorting data by date | Excel Worksheet Functions | |||
| Sorting by date when the date isn't exact | Excel Discussion (Misc queries) | |||
| What formulas are best for sorting by date? | Excel Worksheet Functions | |||
Threaded Mode
