For a start, you don't need the + sign.

Secondly, did you intend not to say
=+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9))
but instead to say
=INDIRECT("'[Apr MIR.XLS]Mid-City'!g"&$a$44+9)) ?
--
David Biddulph

"Libby" wrote in message
...
=+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9))

I am getting an error on this formula, can you tell what is wrong
--
Libby


"David Biddulph" wrote:

=INDIRECT("G"&DAY(TODAY())+6)
or
=OFFSET(G$12,DAY(TODAY()-6),0)
--
David Biddulph

"Libby" wrote in message
...
How do I create a formula to pick a new cell each day of the month. If
today
is the 6 and I want to reference cell g12 and on the 7 I want to
reference
cell g13 and so on.
--
Libby