Need help with formula for calculating age difference

  • Thread starter Thread starter derkris
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate 'exact' age in EXCEL 5
Calculating age from date of birth and ignoring if blank 5
Scrabble Value calculation for Welsh words 0
"how do I calculate age by using date of birth details" 5
create calculated field for age in pivot tables 4
I need to change 4/21/1998 dates to 21/4/1998 HOW? 7
calculate date of birth with an end date and age 1
Count/Calculation According to Age of the Person 1

Back
Top