cell reference
Another if you need 2 digit days:
=indirect("'" & text(a1,"dd") & "'!f17")
or if you don't need 2 digit days:
=indirect("'" & text(a1,"d") & "'!f17")
In both cases, you don't need the $f$17. Since it's a string, it won't change
if you copy that formula to another cell.
Libby wrote:
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
--
Dave Peterson
|