cell reference
The current formula works as is. I'm trying to modify the current formula so
that I don't have to munually change all of the 19's to 20's tomorrow, then
to 21's the next day, then to 22's, etc.
--
Libby
"Libby" wrote:
Here is the formula =+'19'!$F$17 where '19' is referencing a tab name
representing the day of the month. I have multiple formulas in the
spreadsheet referencing the current day of the month sheet ie 19 in this
case. How do I embed a cell reference into the formula so that I can just
change one cell from 19 to 20 to 21,etc rather than going to each formula and
changing it to a 20, 21, etc.
--
Libby
|