ExcelBanter - Figuring Age

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Figuring Age (https://www.excelbanter.com/excel-worksheet-functions/180493-figuring-age.html)

Formula to determine age based on date of birth (08/13/48)?

Try this with your DOB in A1

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

Mike

"Sue" wrote:

Formula to determine age based on date of birth (08/13/48)?

Sue,
The DATEDIF function is undocumented in most versions of Excel.

If the function is alien to you, Chip Pearson has excellent
instructions on how to use it:
http://www.cpearson.com/excel/datedif.htm

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Mike H" wrote in message
...
Try this with your DOB in A1

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

Mike

"Sue" wrote:

Formula to determine age based on date of birth (08/13/48)?