)This would work:

=DATE(1973+62,9,7)

or if the starting date is in Cell A1, again using the sample date of
9/7/73, and the birthdate for 62 years of age is in B1 the formula can be
modified to the following:

=DATE(YEAR(A1)+62,MONTH(A1),DAY(A1))
--
Kevin Backmann


"LiLi" wrote:

Hi

I need to find the date of a person will be 62 years old from his date of
birth. Example if the date of birth is 9/7/73, what will be the date when he
turned 62 years old?

Thank you.