Excel Function/Formula assistance

Copper Contributor

 

Assuming that this is an excel spreadsheet with cell numbers on the left being  2,3,4 etc (just cant seem to fit those number on this page)  Can anyone tell me how I would be able to set up a formula THAT WOULD ADD b1 AND C1 ENDING UP WITH (IN THE FIRST A2 CELL) 1986  THE SECOND 2018 THE THIRD WOULD BE 2019, 2018 ETC.

A1                             B1               C1 

Anniversary DatePolicy DateProduct Name
 11/7/19851
 12/28/200810
 11/11/200910
 10/10/200810
 12/15/200810
 12/3/200715
 9/16/200415
 10/23/200315
 9/8/200815
 9/1/200415
 9/4/201315
 9/28/200815
 9/28/200815
 12/13/201215
 10/12/200715
 12/20/200415
 10/15/200615
 12/28/200615
 11/10/200415
 9/26/200515
 10/27/200815
 11/26/200615
 10/22/200115
 10/13/201115
 11/27/201115
 9/25/200915
 12/28/200215
 10/14/200920
 9/21/200620
 12/11/200620
 10/17/200620
 11/1/200620
 9/15/200620
 9/2/200420
 10/5/200620
 9/9/200420
 12/21/201620
 9/4/201220
 12/14/200620
 12/12/200020
 10/19/200520
 10/19/200520
 11/3/200620
 9/16/200520
 12/28/200420
 10/14/200320
2 Replies

Hello Linda

 

=EDATE(B2,C2*12)

Hello,

 

if you want just the year as the result, you can try

 

=Year(B2)+C2