PDA

View Full Version : Solved: How to get an age from a DOB header with a Stop date?



dexter
01-13-2011, 03:18 PM
I have a spreadsheet that has a long list of patients with lots of information. So im basically trying to figure out how to get the patients age when they where admitted to the hospital which i have a date for that... DOB is in header E1 and date of admission is on header AU....

Both dates are in this type of format 00/00/0000 0:00

Its about 1k patients but they all have a DOB and an admission date... If someone can please help i would be very grateful

Bob Phillips
01-13-2011, 03:41 PM
Try

=DATEDIF(E2,AU2,"Y")&" years "&DATEDIF(E2,AU2,"YM")&" months "&DATEDIF(E2,AU2,"MD")&" days"

dexter
01-13-2011, 03:48 PM
That worked perfectly thank you. =)