In Excel formula to calculate the date someone will hit 65

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Except for February 29th issues:

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