| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
