Sorting Calendar dates

[Guest]

I have a list of birthdays in an Excel Workbook column. How do I sort the data into day/month/year sequence?

 

[Jason Morin]

You could add another column with this formula (assuming
your birthdays are in col. A):

=DAY(A1)&"-"&MONTH(A1)&"-"&YEAR(A1)

and fill down. Now select both column and sort ascending
on the formula column.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a list of birthdays in an Excel Workbook column.

How do I sort the data into day/month/year sequence?

 

[Bob Phillips]

Mike,

If you mean not by strict date order, then you need to add helper columns
with the day, month and year in. Like
B1: =DAY(A1)
C1: =MONTH(A1)
D1: =YEAR(A1)

and then sort on those columns.

--

HTH

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

I have a list of birthdays in an Excel Workbook column. How do I sort the

data into day/month/year sequence?

 

[RAC]

I have a list of birthdays in an Excel Workbook column. How do I sort the data into day/month/year sequence?

Mike,

Just highlight the column the dates are in and then click the Sort
Ascending or Sort Descending Button in the standard toolbar at the top.

RAC

 

[Dave Peterson]

Add a helper column with a formula like this dragged down:

=TEXT(A1,"ddmmyyyy")

But you sure you don't want mmddyyyy? Then all the Januaries, Februaries, ...
will be together.

 

[Earl Kiosterud]

CAREFUL! If you highlight a column, Excel will sort only that column. Sure
messes up your list. Whether you get a warning first or it summarily ruins
your table depends on the version of Excel.

You should select one cell in the column you wish to sort if you're using
the sort button on the toolbar.

 

[2rrs]

Dave's formula works fine; but I think that the formula
=TEXT(A1,"yyyymmdd")which sorts by year, month and day would be my
choice.