Hi,

I have this formula in my worksheet: ='C:\Fordelingsark\[Fordelingsark 2014-15.xlsx]4.2.16'!$AC$90

I want the date (marked in red) to be changed to todays date.

In other words, the formula will change from day to day.

The formula is in cell B3.
The date is in cell B1.

It will be something like this: ='C:\Fordelingsark\[Fordelingsark 2014-15.xlsx]&B1&'!$AC$90

but it won't work.


Any ideas?