=INDIRECT("'"&A1&"'!$F$17") if you want to put your 19 in A1, or
=INDIRECT("'"&DAY(TODAY())&"'!$F$17") if you want it to change
automatically.

As there are no spaces in the sheet name, you could in fact get away without
the single quotes around the '19', so the formula could be simplified
further.
--
David Biddulph

"Libby" wrote in message
...
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