Are they 65 yet?

[Guest]

Hi there. Using E02 on XP. Have a column (A) of dates of birth. What
formula would I use in column B to calculate the date they will turn 65?
I've put in =A1+65 but it adds 65 days not years. Help?!?!?!

Thanks in advance for any help or advice!!!

 

[Bob Phillips]

=date(YEAR(A1)+65,MONTH(A1),DAY(A1))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bernie Deitrick]

Bonnie,

=DATE(YEAR(A1)+65,MONTH(A1),DAY(A1))

HTH,
Bernie
MS Excel MVP

 

[Guest]

Bob, you are EXCELLENT! Just what I needed, it works and so quickly!!!
Thanks!