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

  • Thread starter Thread starter mossy 200
  • Start date Start date
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
 
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
 
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))
 
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
 
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
 
Back
Top