Thread: cell reference
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Libby Libby is offline
external usenet poster
 
Posts: 151
Default 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