I am attempting to create an excel spread sheet that will return a calendar
date. For example, if I enter a person's birth date as 06/27/1964, I would
like to get a returned value date at that person's 65th birth date and in
this case it would be 65 years plus 06/27/1964, which would be 06/27/2029
(Any suggestions).

=date(year(a1)+65,month(a1),day(a1))

if the birthdate is in A1.



Inquiring Mine wrote:

I am attempting to create an excel spread sheet that will return a calendar
date. For example, if I enter a person's birth date as 06/27/1964, I would
like to get a returned value date at that person's 65th birth date and in
this case it would be 65 years plus 06/27/1964, which would be 06/27/2029
(Any suggestions).

--

Dave Peterson