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

[Paniac]

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.

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Paniac" <[email protected]> wrote in message
news:[email protected]...
> 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.

[R.VENKATARAMAN]

in excel 2000 there is a function <datedif> see help



"Paniac" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Ron Rosenfeld]

On Mon, 17 Oct 2005 19:36:02 -0700, Paniac <[email protected]>
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

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)


"R.VENKATARAMAN" <vram26@vsnl$$$.net> wrote in message
news:[email protected]...
> in excel 2000 there is a function <datedif> see help
>
>
>
> "Paniac" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>
>