Sort dates Excel 2007

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I have a large list of dates that I need to sort by only the month and day
(e.g. 9/14) and do NOT want or need the year. I had set up a helper column
originally to do the sort but about two weeks ago any date I added will no
longer sort. My formula appears intact (=text(a2,"mm/dd"). I've even tried to
manually enter the date in the helper column which I normally hide but the
date will then appear as "14 Sep". Obviously there is something very simply
staring right at me to correct this but I'm not seeing it.
 
Make it easier on yourself: make two helper columns with MONTH(A2) and
DAY(A2), then sort on those columns.
 
Back
Top