Excel Function/Formula assistance

Question

&nbsp;Assuming that this is an excel spreadsheet with cell numbers on the left being &nbsp;2,3,4 etc (just cant seem to fit those number on this page) &nbsp;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 &nbsp;THE SECOND 2018 THE THIRD WOULD BE 2019, 2018 ETC.A1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C1&nbsp;Anniversary DatePolicy DateProduct Name&nbsp;11/7/19851&nbsp;12/28/200810&nbsp;11/11/200910&nbsp;10/10/200810&nbsp;12/15/200810&nbsp;12/3/200715&nbsp;9/16/200415&nbsp;10/23/200315&nbsp;9/8/200815&nbsp;9/1/200415&nbsp;9/4/201315&nbsp;9/28/200815&nbsp;9/28/200815&nbsp;12/13/201215&nbsp;10/12/200715&nbsp;12/20/200415&nbsp;10/15/200615&nbsp;12/28/200615&nbsp;11/10/200415&nbsp;9/26/200515&nbsp;10/27/200815&nbsp;11/26/200615&nbsp;10/22/200115&nbsp;10/13/201115&nbsp;11/27/201115&nbsp;9/25/200915&nbsp;12/28/200215&nbsp;10/14/200920&nbsp;9/21/200620&nbsp;12/11/200620&nbsp;10/17/200620&nbsp;11/1/200620&nbsp;9/15/200620&nbsp;9/2/200420&nbsp;10/5/200620&nbsp;9/9/200420&nbsp;12/21/201620&nbsp;9/4/201220&nbsp;12/14/200620&nbsp;12/12/200020&nbsp;10/19/200520&nbsp;10/19/200520&nbsp;11/3/200620&nbsp;9/16/200520&nbsp;12/28/200420&nbsp;10/14/200320

detlef_lewin · Answer

Hello Linda&nbsp;=EDATE(B2,C2*12)

ingeborghawighorst · Answer

Hello,&nbsp;if you want just the year as the result, you can try&nbsp;=Year(B2)+C2

Forum Discussion

Excel Function/Formula assistance

2 Replies

Anniversary Date	Policy Date	Product Name
	11/7/1985	1
	12/28/2008	10
	11/11/2009	10
	10/10/2008	10
	12/15/2008	10
	12/3/2007	15
	9/16/2004	15
	10/23/2003	15
	9/8/2008	15
	9/1/2004	15
	9/4/2013	15
	9/28/2008	15
	9/28/2008	15
	12/13/2012	15
	10/12/2007	15
	12/20/2004	15
	10/15/2006	15
	12/28/2006	15
	11/10/2004	15
	9/26/2005	15
	10/27/2008	15
	11/26/2006	15
	10/22/2001	15
	10/13/2011	15
	11/27/2011	15
	9/25/2009	15
	12/28/2002	15
	10/14/2009	20
	9/21/2006	20
	12/11/2006	20
	10/17/2006	20
	11/1/2006	20
	9/15/2006	20
	9/2/2004	20
	10/5/2006	20
	9/9/2004	20
	12/21/2016	20
	9/4/2012	20
	12/14/2006	20
	12/12/2000	20
	10/19/2005	20
	10/19/2005	20
	11/3/2006	20
	9/16/2005	20
	12/28/2004	20
	10/14/2003	20