Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a reference to a sheet that changes to todays date
Hi,
I have a formula that referst to a cell on particular sheet to get a result. That sheets name is todays date. I add a new sheet with the new date and I want my formula to change automatically to refer to the new sheet? Heres an example of the formula that I currently have to change manually? ='14 Aug 2006'!C8 Is that possible to make the formula dynamic? Any help is greatly appreciated as I have to do this every day. Thanks Sandra |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a reference to a sheet that changes to todays date
In a helper cell (say A1) put this formula:
=TEXT(TODAY(),"dd mmm yyyy") Then use the following formula to access cell C8 in the tab who's name is today's date (formatted "dd mmm yyyy"): =INDIRECT("'"&A1&"'!C8") -- Regards, Dave "Grd" wrote: Hi, I have a formula that referst to a cell on particular sheet to get a result. That sheets name is todays date. I add a new sheet with the new date and I want my formula to change automatically to refer to the new sheet? Heres an example of the formula that I currently have to change manually? ='14 Aug 2006'!C8 Is that possible to make the formula dynamic? Any help is greatly appreciated as I have to do this every day. Thanks Sandra |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a reference to a sheet that changes to todays date
Thats exactly what I wanted
thanks "David Billigmeier" wrote: In a helper cell (say A1) put this formula: =TEXT(TODAY(),"dd mmm yyyy") Then use the following formula to access cell C8 in the tab who's name is today's date (formatted "dd mmm yyyy"): =INDIRECT("'"&A1&"'!C8") -- Regards, Dave "Grd" wrote: Hi, I have a formula that referst to a cell on particular sheet to get a result. That sheets name is todays date. I add a new sheet with the new date and I want my formula to change automatically to refer to the new sheet? Heres an example of the formula that I currently have to change manually? ='14 Aug 2006'!C8 Is that possible to make the formula dynamic? Any help is greatly appreciated as I have to do this every day. Thanks Sandra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping a date when today's date changes | New Users to Excel | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Dynamic reference to a sheet | Excel Worksheet Functions |