Are they 65 yet?
 

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!!!

--
Bonnie

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

--

HTH

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


"Bonnie" wrote in message
...
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!!!

--
Bonnie

Bonnie,

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

HTH,
Bernie
MS Excel MVP


"Bonnie" wrote in message
...
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!!!

--
Bonnie

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


"Bob Phillips" wrote:

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

--

HTH

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


"Bonnie" wrote in message
...
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!!!

--
Bonnie