In Excel formula to calculate the date someone will hit 65

G

gls858

sgwill said:
Using a formula, calculate from birthdate what date a person will turn 65.

Sounds like homework to me. I'll give you a hint.
Google on "calculate age in Excel" no quotes.

gls858
 
D

Dave Peterson

Except for February 29th issues:

With the birthdate in A1:
=date(year(a1)+65,month(a1),day(a1))
 
Top