"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
 
C

Chris Bode via OfficeKB.com

Well, you can use the following formula,
Suppose you have the birth dates in column A then select a cell in any other
column and enter following formula
=YEAR(TODAY())-YEAR(A1)
It will calculate the number of years in between today's date and the
supplied date


Hope this works

Have a nice time

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

Ask a Question

Top