ExcelBanter - How do I calculate an age from a birthdate in excel?

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

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

- - How do I calculate an age from a birthdate in excel? (https://www.excelbanter.com/excel-worksheet-functions/7201-how-do-i-calculate-age-birthdate-excel.html)

CFenton

How do I calculate an age from a birthdate in excel?

How do I calculate an age from a birthdate in excel?

JulieD

Hi

formula from http://www.cpearson.com/excel/datedif.htm#Age

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"

Cheers
JulieD

"CFenton" wrote in message
...
How do I calculate an age from a birthdate in excel?

All times are GMT +1. The time now is 01:04 AM.