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.