Calculating an age from 2 dates
Birthdate in A1 and Visit date in A2...
=DATEDIF(A1, A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"
--
HTH...
Jim Thomlinson
"Terri" wrote:
I am trying to calculate someone's age on a date that is after their
birthday. I know how to do the calculation if I am going from a later date
to an earlier date but how do I go from an earlier date to a later date? for
example,
birthdate visit date
1 12/25/72 8/28/2007
Is there a calculation that can show how old the person was on the visit date?
Thank you!
--
Terri
|