Find the age from date of birth

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ther
Is there any function in excel capable of determinating one's age (and changing it at every birthday) from one's date of birth. The problem is I have a group of around 10 thousand persons to keep and sometiems I forget to actualize it manually

Thanks in advance
 
Antonio,

You can use the DATEDIF function. For example,

=DATEDIF(birthday,TODAY(),"y")

See www.cpearson.com/excel/datedif.htm for more information about
the DATEDIF function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


António said:
Hi there
Is there any function in excel capable of determinating one's
Click to expand...
age (and changing it at every birthday) from one's date of birth.
The problem is I have a group of around 10 thousand persons to
keep and sometiems I forget to actualize it manually.
 
You must log in or register to reply here.

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

How do I calculate a persons age from birth dates 1
How do I calculate a person's age from date of birth and a date 2
date of birth age formula 8
Average of dates of birth 3
Convert date to Age 3
Using Year of Birth, from DOB, in later calculations 5
Birth Date in Range 5
date of birth or blank cell? 3

Back
Top