Sorting Calendar dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of birthdays in an Excel Workbook column. How do I sort the data into day/month/year sequence?
 
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.
Click to expand...
How do I sort the data into day/month/year sequence?
 
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)

Grove Mike said:
I have a list of birthdays in an Excel Workbook column. How do I sort the
Click to expand...
data into day/month/year sequence?
 
Grove said:
I have a list of birthdays in an Excel Workbook column. How do I sort the data into day/month/year sequence?
Click to expand...


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
 
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.
 
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.
 
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.
 
Back
Top