Sorting a date by month, date and then year.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drosh - 29 May 2008 21:23 GMT

I have a list that I exported to Excel that has a name and date of birth
(only 2 columns). I want to sort the list by month, dated and then year.
When I try sorting the list, it always sorts by the year. Do I have to put
in some sort of function to make is sort this way?

Reply to this Message

David Biddulph - 29 May 2008 21:28 GMT

Use helper columns, such as =MONTH(A2), =DAY(A2), =YEAR(A2)
Select the whole range including original data and helper columns, then sort
by the helper columns in your chosen order.
--
David Biddulph

>I have a list that I exported to Excel that has a name and date of birth
> (only 2 columns). I want to sort the list by month, dated and then year.
> When I try sorting the list, it always sorts by the year. Do I have to
> put
> in some sort of function to make is sort this way?

Reply to this Message

willy - 30 May 2008 01:57 GMT

If you have lots of data

Also consider using FILTER

In Excel 07 it with AUTO FILTER it has some default options to choose months
when you go into CUSTOM . Click on the arrows on the title cells.

> Use helper columns, such as =MONTH(A2), =DAY(A2), =YEAR(A2)
> Select the whole range including original data and helper columns, then sort
[quoted text clipped - 7 lines]
> > put
> > in some sort of function to make is sort this way?

Reply to this Message

FSt1 - 29 May 2008 21:31 GMT

hi
you could use 2 helper columns to the right of the data.
assumming the date is in column a....
in the first helper column you could put =month(A2).copy down
this would give you the mouth number of the date
in the second helper column you couldput =year(a2). copy down
this ould give you the year of the date.
you could then sort by the month column then by year.

when finished, delete the helper columns.

Regards
FSt1

> I have a list that I exported to Excel that has a name and date of birth
> (only 2 columns). I want to sort the list by month, dated and then year.
> When I try sorting the list, it always sorts by the year. Do I have to put
> in some sort of function to make is sort this way?

Reply to this Message