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