D
derkris
Hi everyone,
I'm working on an Excelsheet and I need a formula to calculate the ag
of a lot of persons. I'm making a catalogue of hundreds of video's o
people who have been videotapes at several points in their life.
I have their dates of birth and the dates of of the recording and
need to have the age of the people on the day the recording was made.
have tried to use the
< =DATEDIF(A1,B1,"Y") > formula (A1 being the date of birth and B1 th
date of the recording) but it only gives me the age difference in years
I have tried adding a < "D" > and < "M"> near the < "Y" > for date an
month but I get an error when I try that. I'm using Excel 2000. Ca
anyone help me?
Much appreciated
I'm working on an Excelsheet and I need a formula to calculate the ag
of a lot of persons. I'm making a catalogue of hundreds of video's o
people who have been videotapes at several points in their life.
I have their dates of birth and the dates of of the recording and
need to have the age of the people on the day the recording was made.
have tried to use the
< =DATEDIF(A1,B1,"Y") > formula (A1 being the date of birth and B1 th
date of the recording) but it only gives me the age difference in years
I have tried adding a < "D" > and < "M"> near the < "Y" > for date an
month but I get an error when I try that. I'm using Excel 2000. Ca
anyone help me?
Much appreciated