Your approach is good at finding length of service (or age), but does not
sort by month/day of birth. In this given case, it is not a question of a
person's age, but of when their birthday is in order from Jan 1 to Dec 31.
I'm at a loss as to how your suggestion provides this information.

"Ltat42a" wrote:


By doing these two examples duplicates the birthdate. Couldn't you
highlight all the names and birthdates and sort by the birthdate -
either ascending or descending?

I'm using a spreadsheet that determines everybody's time on the job by
their hire date. I first sorted the entire list by hire date, then used
the following forumla to determine how long they have been employed -

=DATEDIF(E3,TODAY(),"m")/12
(E3 contains the first person's hire date)
Put this formula in a cell adjacent to the birthdate column, then copy
down.

Everytime I open this spreadsheet, this will auto update their years of
service (person with the most number of years at the top).


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=393534