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

P

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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

=DATEDIF(A1,B1,"Y")


--ron
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top