How can i add to a cell address? My existing formula isn't working.

[Footahype]

i "need" help with an excel project i'm working on.



i would like to add the number 1,2,3 or whatever amount to an existing cell address. For example cell address $A$2, i want to add 1 to it and display the contents of cell A3.

For example:

Column A Column B Column C Column D
Date Address Add Results
19/05/2004 $A$2 1 20/05/2004
22/05/1970 2
26/05/2016
29/05/2003
02/06/1998

Formulas i have
Cell B2 =ADDRESS(MATCH(A2,A:A,0),COLUMN(A1))
Cell D2 =IF(ISERROR(INDIRECT($B2)+C$2),"---",INDIRECT($B2)+C$2)

However in Cell D2 i get the "incorrect" result 20/05/2004. I want to get 22/05/1970.

Please Help to correct my formula