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.