worksheet function to assign value to cell

[paradox]

Using ADDRESS function I am able to search a table for a specific value and place the address in a cell.
I want to use that address to update the cell's value.

For example, a table of dates named dateBox is searched for a specific date using the ADDRESS function.

When found, the address of the cell containing the date is placed in A15. Lets say the address found is DM12

I need to take the current value residing in A15, add 14 to it and replace the old value in DM12 with the new value.

Is there a worksheet function to handle this?

Thanks in advance.

[shg]

The simple answer is no, you can't.

The more complicated answer it that it would require either a circular reference with a single iteration, or VBA.