Sort Dates by Month and Day, Not Year

[Al Franz]

Is there a trick to sort a date column by Month and Day, and not have it
sort the list by year as first sort. Without breaking up the data into
multiple columns.

 

[Shane Devenshire]

Hi,

You could add a column with the formula

=YEARFRAC(DATE(YEAR(A1),1,1),A1)

and sort on that column. It does sound like you want to avoid this.

If your dates are the row field of a pivot table and your group by month and
day Excel will ignore the year.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Dave Peterson]

I'd use a formula like this in a helper column:

=text(a1,"mmdd")

Then sort the data by that helper column.

 

[Al Franz]

Thanks Dave that helps. Still haven't gotten my desired result, but if you
have a minute maybe can take a look at the following....

http://netmation.com/dateprob.xls

Can see the formula I am currently using and see if there is a way to get
the forumula to give me the desired results. The cells in red are the
desired results the formula is not working for.

 

[Dave Peterson]

I don't open files.

Remember that this formula only works on dates--not text. If it's not working,
I bet your "dates" aren't dates--just plain old text.