[diggeryo]

I have a long list of things with one column containing dates in the format: January 01, 2001.

I'd like to sort by the date column by Month and Date, with January 01 being the first row and December 31 being the last row, regardless of year. However, everytime I sort, it sorts it by year. Even when I followed the help offered in Excel itself, where it told me to click "options" under sort and choose the month option, it still sorted by year.

Any help would be appreicated.

thanks,
mike.

[Advertisements]

Hi Mike...again,

How are your columns formatted?

Is it like this?

Date Data Data 2 Data 3

Or like this?

Day Month Year Data


Let me know.


Cheers:)

[Dockboy]

Hi Mike...again,

How are your columns formatted?

Is it like this?

Date Data Data 2 Data 3

Or like this?

Day Month Year Data


Let me know.


Cheers:)

[diggeryo]

I have one column with the entire date in it (in the following format: January 01, 2001).

I wanted to sort it so all the months would be clumbed together in order regardless of the year but couldn't seem to get it to sort properly when sorting by the column that had the date in it.

I figured a workaround for it, though. I created an additional column and put in the formula "=MONTH(B1)" so that this additional column would show the number for the month (January=01, February=02, etc.). I then sorted by this additional column.

It got the result of was looking for, but there has to be an easier way to do it.