sorting by dates

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a list of Birthdays which includes the year. I am
trying to sort the list excluding the year so each
monthes B-days will be together, and in order. When I
sort it always considers the year with it. What am I
doing wrong?

Scott
 
Scott,

It is bound to include the year if you sort the whole field.

You could create an extra column that extracts just the day and month, and
sort both columns, with the second column as the key. An example formula for
the second column is
=TEXT(DAY(A1),"00")&TEXT(MONTH(A1),"00")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Nothing. Excel is doing exactly what you have asked it to do. Insert a dummy
column next to the dates, and then assuming your dates are in Col A and Dummy
Col is B, in B2 put the following formula:-

=DATE(0,MONTH(A2),DAY(A2))

and then format the cell as Date / Custom mmm-dd

then copy and paste down as far as you need to go. Now simply sort on that
column. It will give all the dates the same year, so don't use it for anything
else.
 
One more way:

Use a helper column with a formula like:

=text(a1,"mmdd")

drag down and sort by this column.
 
Back
Top