new cell each day

[Libby]

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.

 

[David Biddulph]

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

 

[T. Valko]

*Maybe* this:

=INDEX(G7:G37,DAY(NOW()))

 

[Libby]

Thanks, the indirect is what I was looking for.

 

[Libby]

=+'[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]

What I am trying to do is use the date field in one workbook to reference the
cell of another workbook. so if today is the 6 then it will pull cell g12 in
another workbook.
--
Libby

=+'[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

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

 

[David Biddulph]

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

=+'[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

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

 

[T. Valko]

....and the source file will need to be open for this to work.


--
Biff
Microsoft Excel MVP

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

=+'[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

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

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.

 

[David Biddulph]

Yes. The OP has already said [in another thread, naughty girl!] that the
file is open.
--
David Biddulph

...and the source file will need to be open for this to work.


--
Biff
Microsoft Excel MVP

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

=+'[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


:

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

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.