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

[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

 

[Mike H]

Hi,

try this with a birthdate in A1

=DATEDIF(A1,TODAY(),"y")

Note that datedif isn't documented in Excel, for help look here

http://www.cpearson.com/excel/datedif.htm

Mike

 

[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

 

[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

 

[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))

 

[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

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

 

[Mike H]

Email sent

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

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