View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default In Excel formula to calculate the date someone will hit 65

Except for February 29th issues:

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



sgwill wrote:

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


--

Dave Peterson