Sort Dates by Month and Day, Not Year

  • Thread starter Thread starter Al Franz
  • Start date Start date
A

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.
 
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
 
I'd use a formula like this in a helper column:

=text(a1,"mmdd")

Then sort the data by that helper column.
 
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.
 
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.
 
Back
Top