Work oiut a persons age at a given date

  • Thread starter Thread starter NeilT
  • Start date Start date
With date of birth in A1 and the date in B1; try the below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "

'as of today
=DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&" months "

For details around calculating age refer
http://www.cpearson.com/excel/datedif.aspx

'Another option. Please note the difference of the below funciton when
compared with DATEDIF
=--TEXT(TODAY()-A1,"yy")

If this post helps click Yes
 
=DATEDIF(A2,B2,"y")
A2: date of birth
B2: given date

Regards,
Stefi

„NeilT†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating someone's age at a given date 12
How do I calculate a persn's age in years & months in Excel? 4
Calculating age from date of birth and ignoring if blank 5
Formula to Return age 2
Calculating present age if date of birth is given. 3
calculating ages 3
"how do I calculate age by using date of birth details" 5
Count/Calculation According to Age of the Person 1

Back
Top