='K:\Actual Orders vs Forecast\2010 Actual vs Forecast\[2.15.10 to
2.19.10.xls]Friday'!$D$3

That is currently the hyperlink I have and I have to manually change the day
every day. I have written the concatenate formula

=CONCATENATE("='K:\Actual Orders vs Forecast\2010 Actual vs
Forecast\[",TEXT(F1,"mm.dd.yy"), " to
",MONTH(F1+4),".",DAY(F1+4),".",RIGHT(YEAR(F1+4),2 ),".xls]",TEXT(C1,"dddd"),"'!$G$3")

With F1 holding the Monday of the Week; c1 containing the current day


"T. Valko" wrote:

I've created a concatenate formula that gives me a link

The cell that I would like to reference is linked in a
different worksheet--so does that cause the
indirect function to be moot?

No. Post your concatenate formula so we can see what you're trying to do.

--
Biff
Microsoft Excel MVP


"phd4212" wrote in message
...
The cell that I would like to reference is linked in a different
worksheet--so does that cause the indirect function to be moot?

"Luke M" wrote:

Check out the INDIRECT function.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"phd4212" wrote:

Is it possible to have a link to another cell that is derived from a
concatenate formula?

I have a spread sheet that is created weekly that displays our daily
forecasts. Each week is stored in the same spreadsheet, but the
individual
day's forecast location differs. I've created a concatenate formula
that
gives me a link to the formula as it should read in the spreadsheet,
but I
cannot get the data in the other spreadsheet to populate....any help?


.