Not sorting by year....actually sorting from earliest to latest or visa versa.
You should add a column with the following formula for each date:

=month(a1) where a1 is the first date/month you want sorted.

The month formula will return the number 1 through 12 regardless of the year
of the actual date. Then you can sort by your new column....

Alternatively if you don't care about the yearly data, you could convert all
the data to the same year.

HTH

HTH

"Winnie" wrote:

I try to sort the list of date by Month. But Excel only can sort by year.