How to Use the Offest Function inExcel

http://support.microsoft.c

For instance the following formula sums the values of the two adjacent cells above-left, and above, with the one above itself:

=SUM(OFFSET(D7673, -1, 0), OFFSET(D7673, 0, -1))

Once this formula is set in Cell D7673, it can be copy/pasted into any cell and retrieve the same relative sum.

=CONCATENATE("Birthday: "& TEXT(OFFSET(formula),"mm/d

..may be what you are looking for.