Cell A1 has a date of, for example, 12/04/2005. I would like to put a formula in Cell B1 which will add 65 years to the date on A1, and should therefore = 12/04/2070.
Thus, when I enter dates down Column A, I can drag the formula down from B1, and Excel will automatically add 65 years to every date in Column A.
Effectively, this formula is A + 65 years = B. Unfortunately, Bill Gates doesn't agree!
Please can someone help me?
Bookmarks