Formula for adding years to a date and rounding the date out


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)

Cell-A4 formula

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.

By: Shanee

324 thoughts on “Formula for adding years to a date and rounding the date out

  1. As Melhores Listas Iptv Pagas

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. Burbank realtor

    Nice blog here! Also your website loads up fast! What web host are you using? Can I get your affiliate link to your host? I wish my web site loaded up as fast as yours lol

  3. Dong

    You ave made some really good points there. I looked on the web for additional information about the issue and found most individuals will go along with your views on this web site.

Comments are closed.