How do I sort by month and day

C

CVSTANFORD

I want to sort multiples dates by day and month, but NOT year. Basically to
put all of our birthdays in order for the year.........
 
G

Gary's Student

Let's assume that all your dates are some column, say column B
In another column, enter the formula =MONTH(B1) and copy down.
In a third column, enter =DAY(B1) and copy down.

Then sort the data by month and then by day.
 
E

Eric Conditt

CVSTANFORD said:
I want to sort multiples dates by day and month, but NOT year. Basically to
put all of our birthdays in order for the year.........
Click to expand...

You could take out the month and day from the string and sort them that way.

Put this in cell B1 of a new book and put a date in cell A1...

=VALUE(MONTH(A1)&"/"&DAY(A1))

If you entered a date like 2/14/1977 it would take that and change it into
2/14/(2005 or current year). Once you have a column created you can just sort
by that.

A B
2/14/1977 2/14/2005
4/5/2000 4/5/2005
4/11/2000 4/11/2005
4/12/1980 4/12/2005
4/29/1981 4/29/2005
5/21/2004 5/21/2005
 
E

Eric Conditt

The formula got messed up on the HTML display :(

You would need to write it like...

=VALUE(MONTH(A1)&(double quote)/(double quote)& DAY(A1))

sorry about that, if you are unsure about what I mean just hit reply to this
and it will display the formula corretly in the text box.

=VALUE(MONTH(A1)&"/"&DAY(A1))
 
B

Bob Phillips

Add a formula of =TEXT(A1,"mmdd") in an adjacent column, copy down, sort
both columns with the helper column as key.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
C

CVSTANFORD

It works great Bob! Thanks so much!!!

Bob Phillips said:
Add a formula of =TEXT(A1,"mmdd") in an adjacent column, copy down, sort
both columns with the helper column as key.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top