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

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

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

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

"mossy 200" wrote:

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

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

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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

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

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

"Chris Bode via OfficeKB.com" wrote:

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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

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

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mossy 200" wrote:

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

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

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" wrote in message
...
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

"Chris Bode via OfficeKB.com" wrote:

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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

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

Email sent

"Bob Phillips" wrote:

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" wrote in message
...
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

"Chris Bode via OfficeKB.com" wrote:

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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1