I have a date in cell D3 AND THEN IN CELL C2 I HAVE THIS FORMULA:
=DATE(YEAR(D3)+1,MONTH(D3),DAY(D3)-1)
Which adds the date for review a year on. but when I need to insert the cell to the right to add a new date it changes the formula to cell E3 and i want it to stay in D3 and calculate from the new date. i have tried indirect function but i cant get it to work with the date format
Please help
indirect