Age Calculation
Joan V wrote:
What is the best way to calculate age as of a certain date (as in age of a
person as of 12/31/2006)?
Hi John,
I think that one way would be to use this:
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"
Where the date of birth is in A1 and the date is in A2
Regards,
Bondi
|