Use the Datedif function, which is undocumented, except in XL2K.

Find instructions at Chip Pearson's site:

http://www.cpearson.com/excel/datedif.htm
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"krakowba" wrote in message
...
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.