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.

)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.

Hi Lili,

If the date of birth 9/7/73 is in cell a1, you could use
=DATE(YEAR(a1)+62,MONTH(a1),DAY(a1))


"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.

That's the same anwers as when the age was 65. Will there be another post
for age 60?

"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.