cell reference
Hi Libby,
You don't need the + sign. Make sure you have ToolsOptionsTransitionall items unchecked, unless you explicitly need them
Look in HELP for the INDIRECT() function
Post again in this thread if you can't get it done
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Libby" wrote in message ...
| 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
|