Referencing a cell from a workbook that is named by date

You would normally do something like this using INDIRECT(). However, that only works on open workbooks (the file you are referencing needs to be open too)

If this will not be feasable (dont want the otehr file open), thenb take a look at using the Morefunc add-in. Find it here...
http://www.ashishmathur.com/tag/morefunc/

No, the Morefun works on file names converted from cell text entries. You enter the "name" into a cell, MF converts that - along with the rest of your sheet name/cell ref into something excel can then use in a formula. This what a sample would look like using INDIRECT(). Morefunc works kinda the same way...

	K	L
21		Richard
22	Sample	Richard

K22=your file name
L21=[sample.xlsx]Sheet3!$B$1
This is what the formula would look like if the file name was not variable
L22=INDIRECT("["&K22&".xlsx]Sheet3!$B$1")
This is what that same formula would look like using INDIRECT() with a vairable file name