It is sorting alphabetically because the data is in TEXT format. In order
to sort by date, you'll need to have the data formatted in some kind of DATE
format. I'd guess that the type "Mar-01" is the one that you'd want. If
you want to sort by MONTH and YEAR, you'll have to have a column of MONTH
only and another of YEAR only and sort by those.

If someone has a more elegant solution, please let me know.

"GEORGIA" wrote:

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!