Dates

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

If I have a column that has a date of birth and another
column that has an arrest date, how could I do a formula
that would give me the age of the person when they were
arrested. This is on juveniles and I need to know the age
when the citation was given. Can this be done?
 
Pam, birthday in A1 and arrest date in B1
=DATEDIF(A1,B1,"y")&"y,"&DATEDIF(A1,B1,"ym")&"m,"&DATEDIF(A1,B1,"md")&"d"

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
One note:

This formula can give you some strange answers. DATEDIF seems to
assume that months are based on the first date's month length, so

A1: 31-Jan-1987
B1: 1-March-2003

returns

16y,1m,-2d

The problem is inherent in the imprecise definition of "month".
 
Back
Top