MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I calculate someone's age using excel?


Posted by Aimee on September 12, 2001 11:35 PM

Hi,
I want excel to calculate ages of people on a list - I've entered their dates of birth in another column, could you please tell me the formula to calculate their ages?
Thanks.
Aimee.


Posted by Richard S on September 12, 2001 11:57 PM

Aimee,

=(NOW()-A2)/365.25 where A2 containes DOB. Format as general. This will get you pretty close. Or if you want it at a specific date, enter that date in say cell C1, then =($C$1-A2)/365.25 and copy as needed. Change the date in C1 to whatever you want.

Richard

Posted by iml on September 13, 2001 8:12 AM

One other formula

Assuming your first birth date is A1, use
=YEAR(NOW())-YEAR(A1)-(MONTH(NOW())<MONTH(A1))-((MONTH(NOW())=MONTH(A1))*(DAY(NOW())&LT;DAY(A1)))

If Richard's is proving accurate enough for your needs, then I would use that one.

good luck

Posted by IML on September 13, 2001 2:51 PM

Posting problem

Looks like this was already addressed above as well, but since my first post failed here is a second attempt.
=YEAR(NOW())-YEAR(A1)-(MONTH(NOW()) &LT; MONTH(A1))-((MONTH(NOW())=MONTH(A1)*(DAY(NOW()) &LT; DAY(A1))))

Crazy less than signs.