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.
|