How do I calculate ages in excel using date of birth & another dat
 

Using excel 2003 I wish to insert a column with a date of birth and another
column with another date eg 1/1/2005. I would then like to calulate the age
of each person in my list as at 1 Jan 05.

How do I calculate ages in excel using date of birth & another dat
 

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Paniac" wrote in message
...
Using excel 2003 I wish to insert a column with a date of birth and
another
column with another date eg 1/1/2005. I would then like to calulate the
age
of each person in my list as at 1 Jan 05.

How do I calculate ages in excel using date of birth & another dat
 

in excel 2000 there is a function <datedif see help



"Paniac" wrote in message
...
Using excel 2003 I wish to insert a column with a date of birth and
another
column with another date eg 1/1/2005. I would then like to calulate the
age
of each person in my list as at 1 Jan 05.

How do I calculate ages in excel using date of birth & another dat
 

On Mon, 17 Oct 2005 19:36:02 -0700, Paniac
wrote:

Using excel 2003 I wish to insert a column with a date of birth and another
column with another date eg 1/1/2005. I would then like to calulate the age
of each person in my list as at 1 Jan 05.

If dob is in A1, and the other date in B1, then:

=DATEDIF(A1,B1,"Y")


--ron

How do I calculate ages in excel using date of birth & another dat
 

Excel 2000 is the only version that has a help section about datedif

--
Regards,

Peo Sjoblom

(No private emails please)


"R.VENKATARAMAN" wrote in message
...
in excel 2000 there is a function <datedif see help



"Paniac" wrote in message
...
Using excel 2003 I wish to insert a column with a date of birth and
another
column with another date eg 1/1/2005. I would then like to calulate the
age
of each person in my list as at 1 Jan 05.