Create a formula that determines a date-sensitive File-Name from w

S

stan-the-man

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?
 

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

averaging from different sheets and folders 1
help on indirect() 1
match dates in two columns get value from third 1
Set destination sheet based on variable and paste data assistance 13
Use Text and Cell vale to reference a named range inside a formula 4
Capturing Trend Data over time 1
Recording Historic Trend Data 1
Summing values for a range of dates 2

Top