Create a reference to a sheet that changes to todays date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
Thats exactly what I wanted
thanks

David Billigmeier said:
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")
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Automatic Sumning of Same Cell from Different Sheets 3
Dependent drop down dynamic range formula, off sheet. 7
Formulas That Reference ADJACENT Sheet 4
Excel How to get the number of days an item was opened from the today's date. 14
sheet name in workshhetfunction 2
Date + relative number reference 3
Excel Dragging countif formula with changing criteria 3

Back
Top