Find future dates

L

LiLi

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

Kevin B

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

Anthony D

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

JLGWhiz

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