To most people, age in years means the age attained on the most recent
birthday.

OTOH, your formula returns the age the person WILL ATTAIN on their birthday in
the current year. If the birthday hasn't occurred yet, your result is high by
1 year.

A person born on Nov 10, 1950 is 54 from 11/10/2004 through 11/9/2005, 56 from
11/10/2005 through 11/9/2006.

You can't get those results by simply comparing years. You also have to take
the month and day of the month into account, for both dates.


On Wed, 16 Feb 2005 23:46:50 -0800, Claud Balls wrote:


Where A1 is the birthday, the cell with the formula returns the age.
=RIGHT(YEAR(TODAY()-A1),2)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!