Sort dates Excel 2007

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.
 
D

David Biddulph

Two points to remember when you sort.
Firstly, remember to select the range of rows and columns which you wish to
sort; it isn't advisable to allow Excel to guess the range.
Secondly, you may be offered the choise of whether to treat text which looks
like a number as a number; be careful how you answer that.
 
A

Andy Smith

Make it easier on yourself: make two helper columns with MONTH(A2) and
DAY(A2), then sort on those columns.
 
Top