Hi
Have a look he
http://www.cpearson.com/excel/datedif.htm#Age
Andy.
"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.