Chip, I do appreciate your hint of using INDIRECT. And while it helps set my
references for all the sums I need to do, I'm still wondering if there is a
function to extract the row number from a cell referencing another cell.

I have ='sheet1'!A22 in a cell which references a date, so displayed value
is 01/04/05. I need to change this date to reference a different row in
column A so that the ton of summaries are also changed. While the INDIRECT
lets me make massive changes without 'Replace All' I still would like to set
the value used by INDIRECT dynamically so that the cell used would have a
value of 22. And when I change to A99, it would have 99.

I tried the MID function to get to"22", tried using CONCATENATE with a
leading single quote to convert formula to text, but I think my problem is
that the cell is not text and those function can't deal with the formula in
the cell.

I may be asking for a function that doesn't exist in Excel, but I'm hoping
I'm wrong.

Thanks for any assistance/guidance.