Find future dates
 

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.

Find future dates
 

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

Find future dates
 

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.

Find future dates
 

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.