# "how do I calculate age by using date of birth details"

M

#### mossy 200

Help

I am trying to calculate age on the spreadsheet.
What cell formula do I need to use to get the age of a person if I have
their birth date?
Thanks

M

M

#### Mike H

That may or may not give you the age.

Try it with a birthday of 1/9/81 and todays date and you get a result of 28
but that person isn't 28 ubtil 1/9

Mike

S

#### Shane Devenshire

Hi,

I personally favor DATEDIF but if you don't like using an undocumented
function then

=TRUNC(YEARFRAC(A1,TODAY(),1))

Where the birthday is in A1.

For this work you could also choose:

=DATEDIF(A1,NOW(),"y")
or
=TRUNC(YEARFRAC(A1,NOW(),1))

B

#### Bob Phillips

Mike,

Can you drop me an email? I have a problem I want to discuss with you.

Email is bob dot phillips at tiscali dot co dot uk

--
__________________________________
HTH

Bob

Mike H said:
That may or may not give you the age.

Try it with a birthday of 1/9/81 and todays date and you get a result of
28
but that person isn't 28 ubtil 1/9

Mike

M

#### Mike H

Email sent

Bob Phillips said:
Mike,

Can you drop me an email? I have a problem I want to discuss with you.

Email is bob dot phillips at tiscali dot co dot uk

--
__________________________________
HTH

Bob

Mike H said:
That may or may not give you the age.

Try it with a birthday of 1/9/81 and todays date and you get a result of
28
but that person isn't 28 ubtil 1/9

Mike

## 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.