I have two columns in a sheet, approx 1000 rows. A1:A1000 contain the
purchase date (i.e. 1/1/2000). I need to have B1:1000 display the date 3
years from the purchase date. I do not want to add this in manually for each
column, so I was hoping there was a way to do something like
=date(year(address(row(), column()-1, 4) +3, month(address(row(), column()-1,
4), day(address(row(), column()-1, 4)).

In my view, this looks at the year, month, and day for each cell that is in
the same row that formula is, and one column to the left. it adds 3 years,
and displays the same month and day value.

I think I'm close to getting it, but the function errors out.