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

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?

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


=(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.


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

One other formula

Assuming your first birth date is A1, use

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.

Crazy less than signs.