Date Sort

  • Thread starter Thread starter kuri
  • Start date Start date
K

kuri

How do you sort a list of birth dates so that they are in
order for the year, this would be for a birthday list for
staff. The format of the data is dd:mm:yy.
 
Whatever the format is, any dates (with times) will be sorted with the order of year, month, day(, hour, minute, second).
Why don't you try first before asking?
Did you have any problem?
 
kuri said:
How do you sort a list of birth dates so that they are in
order for the year, this would be for a birthday list for
staff. The format of the data is dd:mm:yy.
Click to expand...

You need to make a 'helper' column with formulas to convert each date to
have the same year, and then sort on that.

For this, you could use a formula such as
=DATE(2003,MONTH(A1),DAY(A1))
copied down. It doesn't matter what year you choose (1 would be just as good
as 2003) - they just need to be the same as each other.
 
Back
Top