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

[dexter]

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]

Try

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

[dexter]

That worked perfectly thank you. =)