Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|