=INT((A2-A1)/365)
and
=DATEDIF(A1,A2,"Y")
will both return the number of years between two dates. A1 is the
birthdate, and A2 is TODAY(). You might need to reformat the cell as general
after you put in the formula (it might try and output as a date otherwise).

You can also use the DATEDIF to get something like
22 years and 5 months
with this formula
=DATEDIF(A1,A2,"Y")&" years, and "&DATEDIF(A1,A2,"YM")&" months."


"krakowba" wrote:

I want to develop a quick list of friends and family's ages. How do I get
Excel to work out someone's age from their date of birth.

I've tried using the Year function but that seems to round up to the nearest
full year - so someone who is say 21 will be shown as 22 as it merely
subtracts in whole years.