"Stephen Rainey" wrote in message
...
"Ardus Petus" wrote in message
...
=INDIRECT(CONCATENATE("=[parts",MONTH($A21),"]widgets",DAY($A21),"$B$99")
&"]widgets"&FORMAT(DAY($A21),"00")&"$B$99"))

Not tested, but should work...

Hi AP, thanks for your help with this..
I have just had a breakthrough/down and have it working using the
following
=INDIRECT("'C:\PATH\[Daily
Log-"&TEXT(F9,"yyyymmdd")&".xls]Activities'!$F$2").
I simplified the concatenation to get the basic functionality working,
and I think that I can now adopt this to my original problem.

BTW: if =FORMAT(DAY(F20),"00") is put into a cell, the
following error is generated. #NAME?

Do I need to install something? What am I missing ?

As far as I am aware, there isn't a function FORMAT() in Excel, only in VBA.
Ardus can hopefully explain what he intended?
--
David Biddulph