I think that will work. Thanks!

"Bondi" wrote:


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