Recalculation

**xlearner** · 02-20-2011, 12:13 PM

I have a worksheet containing many formulas of the form:
=WORKDAY(INDIRECT("J" & ROW()),10,PHD)
to create a date 10 working days after that in a previous cell in the row,
PHD is the name of a Range containing Public Holiday Dates.

This works fine except that the entire sheet recalculates whenever a Date is changed.
I gather this is due to ROW() being a Dynamic function.

Can anyone suggest a way of avoiding the use of ROW() and/or limiting the recalculation to the current row?

**Cutter** · 02-20-2011, 12:27 PM

It's the INDIRECT() function that is volatile.

See this link:

http://www.decisionmodels.com/calcsecretsi.htm

It doesn't seem necessary for you to use it. Just refer to the previous cell.

**xlearner** · 02-20-2011, 01:06 PM

Thanks 'Cutter' for that. I wondered now why I had introduced Indirect in the first place. I think it may have been because:
=WORKDAY("K" & ROW(),10,PHD) did not work.
Perhaps, in my ignorance, I am missing something!