Calculating Age from Birthdate

M

Murph

Is there a function available that calculates today's age
from a birthdate? If so, what is it? If not, can
someone tell me how to create a spreadsheet where I can
calculate current age from being given a birthdate?

Thank you.
 
J

James Silverton

Murph said:
Is there a function available that calculates today's age
from a birthdate? If so, what is it? If not, can
someone tell me how to create a spreadsheet where I can
calculate current age from being given a birthdate?
Click to expand...
Suppose the birth date is in column A

Age=FLOOR((NOW()-A1)/365.24,1)

This should be close enough for government work. The FLOOR could be
omitted if you will accept the age as a decimal number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Age based on birthdate 2
Excel formula calculating age 4
How do I calculate age using a 12 digit social security number in MS Excel? 0
Age from birthdate 9
Calulating Age Formula 3
date formula assistance req'd 5
Birth date from age 2
How do I calculate an age from a birthdate in excel? 1

Top