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())<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()) < MONTH(A1))-((MONTH(NOW())=MONTH(A1)*(DAY(NOW()) < DAY(A1))))
Crazy less than signs.
