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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem sorting by date after 2029 on Excel 2003 1
sorting by date in excel 4
excel won't sort dates correctly 0
UNABLE TO SORT DATE 1
Sort Issue 2
Excel 2002: How to make the date format uniform ? 1
Date Formatting & Sorting 2
Conditional Formatting or VBA 2

Back
Top