Discussion Locked

calculate age in excel

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

how do I calculate a person's age using Excel & today's date?
I have had several attempts & all have failed, returning figures such as 7 years 13 months! or 7 years & 12 months

6 replies

by larry h.

If cell A1 contains the Date of Birth in some other cell type:
=TEXT(TRUNC((NOW( )-A1) / 365.25),0)&" years and "&TEXT(MOD(NOW( )-A1,365.25)/30,0) & " months."

This discussion is closed to new replies.