ExcelBanter - What is the formula to calculate Age when I have Date of Birth?

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

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

- - What is the formula to calculate Age when I have Date of Birth? (https://www.excelbanter.com/excel-worksheet-functions/5439-what-formula-calculate-age-when-i-have-date-birth.html)

Katiemcgi

What is the formula to calculate Age when I have Date of Birth?

I am trying to create an Age column based on the DOB (Date of Birth). What
is the formula for the Age Column??

Chip Pearson

Use the DATEDIF function. E.g.,

=DATEDIF(date_of_birth,NOW(),"y")

See www.cpearson.com/excel/datedif.htm for more details about
DATEDIF.

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

"Katiemcgi" wrote in
message
...
I am trying to create an Age column based on the DOB (Date of
Birth). What
is the formula for the Age Column??

All times are GMT +1. The time now is 12:43 PM.