View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
krakowba
 
Posts: n/a
Default How do I work out people's exact ages from their Dates of Birth?

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.