I am trying to create a formula, or function, that determines a
date-sensitive File-Name from which the cell's value should come. Please note
the example below:

Historical files are saved as of a specific date:

'[dailies-11082004.xls]dailies'!$B4
'[dailies-11092004.xls]dailies'!$B4
'[dailies-11102004.xls]dailies'!$B4
'[dailies-11112004.xls]dailies'!$B4

I want to calculate, in a cell function, to say:

"What was the value of $B4 seven days from today() - or from 38308 (excel's
value for today rounded down to the integer value)"

Is this possible?