Dates

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?
 
P

Paul B

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 **
 
J

J.E. McGimpsey

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

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

Display weeks from a Milestone 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0
calculate average values for 100 records in the shortest way? 5
Help counting multiple checkboxes in a form to make a total in a report 3
calculate date of birth with an end date and age 1
"how do I calculate age by using date of birth details" 6
Data type mismatch error --> text to date 1
How can the font and size of (all) citation numbers be altered? 1

Top