new cell each day
 

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

new cell each day
 

=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

new cell each day
 

*Maybe* this:

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

--
Biff
Microsoft Excel MVP


"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

new cell each day
 

Thanks, the indirect is what I was looking for.
--
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

new cell each day
 

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

new cell each day
 

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


"Libby" wrote:

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

new cell each day
 

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

new cell each day
 

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


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

new cell each day
 

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

"T. Valko" wrote in message
...
...and the source file will need to be open for this to work.


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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