Converting Date of Birth to Age
 

Can anyone please help me? is there a function in excel to convert Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy

I should have added that I have subtracted today's date then divided by 365,
converted to a number field - but this seems a bit crude!

Thanks again

Wendy

"WendyMc" wrote:

Can anyone please help me? is there a function in excel to convert Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy

See:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
Can anyone please help me? is there a function in excel
to convert Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy
.

use <datedif function .see help


WendyMc wrote in message
...
Can anyone please help me? is there a function in excel to convert Date
of
Birth data into Age? or a forumula to help?

Many thanks
Wendy

If the age is in a separate column use
=YEAR(TODAY())-YEAR(A2- the column with the birthdate in
it)Will calc age each time you open the worksheet


-----Original Message-----
use <datedif function .see help


WendyMc wrote in
message
news:BFCB9791-666F-4B1D-91E8-
...
Can anyone please help me? is there a function in
excel to convert Date
of
Birth data into Age? or a forumula to help?

Many thanks
Wendy


.

In general, it isn't documented in Help. I believe you could find it in
XL2000(?), but it isn't there in other versions.

On Thu, 3 Feb 2005 18:47:19 +0530, "R.VENKATARAMAN"
$$$ wrote:

use <datedif function .see help


WendyMc wrote in message
...
Can anyone please help me? is there a function in excel to convert Date
of
Birth data into Age? or a forumula to help?

Many thanks
Wendy

Your formula will calculate the age the person will attain on their birthday
in the current year, not necessarily the age they would report today.

Let's say a person was born on December 31, 1970. On January 1, 2005, your
formula says the person is 35. He/she won't be 35 for almost 12 months.


On Thu, 3 Feb 2005 06:30:09 -0800, "PAR"
wrote:

If the age is in a separate column use
=YEAR(TODAY())-YEAR(A2- the column with the birthdate in
it)Will calc age each time you open the worksheet


-----Original Message-----
use <datedif function .see help


WendyMc wrote in
message
news:BFCB9791-666F-4B1D-91E8-
...
Can anyone please help me? is there a function in
excel to convert Date
of
Birth data into Age? or a forumula to help?

Many thanks
Wendy


.

This will return decimal years;
=DATEDIF(A1,B1,"d")/365.25



WendyMc wrote:
I should have added that I have subtracted today's date then divided
by 365,
converted to a number field - but this seems a bit crude!

Thanks again

Wendy

"WendyMc" wrote:

Can anyone please help me? is there a function in excel to convert
Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy

If you are going to use "d" as the 3rd argument to DATEDIF, you can forget the
function and just subtract. Your formula is the same as (B1-A1)/365.25.

That formula can give errors when the 2nd date is very close to the birthday,
with the age changing a day or two early or late.

For example, if the birthdate is 1/15/2003, the age does not pass 1 until
1/16/2004. On 1/15/2004, when it should be exactly 1, the result is 0.999316.

The correct formula for age in years is =DATEDIF(A1,B1,"y")


On 3 Feb 2005 19:32:38 -0800, "2rrs" wrote:

This will return decimal years;
=DATEDIF(A1,B1,"d")/365.25



WendyMc wrote:
I should have added that I have subtracted today's date then divided
by 365,
converted to a number field - but this seems a bit crude!

Thanks again

Wendy

"WendyMc" wrote:

Can anyone please help me? is there a function in excel to convert
Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy