Sorting by birthdate

S

Sillysamiam

OK, thanks to several on this newsgroup, I have found out how to change
02251998 to February 25, 1998.

Now, when I try to sort these dates, it sorts by the year first.

Is there a way to sort by the month (January), then the day, and then the
year.

OR,

is there a way to put the year in the next column, the month in the column
after that and the day in the third column?

I need to be able to sort the dates by the month, then the day, then the
year.

Thanks for the past help
 
B

Bob Phillips

Add a helper column, with a formula of

=TEXT(MONTH(A1),"mm")&TEXT(DAY(A1),"dd")&YEAR(A1)

and sort both columns, with the helper column as the key.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

You can put the year, month, day in separate columns by using:

=year(a1)
=month(a1)
=day(a1)

But you could use a helper column (like Bob's suggestion) and use a different
formula:

=TEXT(A1,"mmddyyyy")

And sort by that helper column.
 
Top