Here is my problem:
Cell- A1 has a date of 3/15/1950
Cell-A2 has number of 65
Cell-A3 has a date of 1/1 (no year)
What would the formula be to add the years from A2 to A1 and round the date up to the month and day put in A3?
I am looking for A4 to have the answer 1/1/2016.