"David Biddulph" <david@biddulph.org.uk> wrote in message
news:4458cead$1_1@glkas0286.greenlnk.net...
> "Stephen Rainey" <stephenrainey@hotmail.com> wrote in message
> news:OivpoXsbGHA.4604@TK2MSFTNGP02.phx.gbl...
>> "Ardus Petus" <ardus.petus@laposte.net> wrote in message
>> news:emO3H6gbGHA.3320@TK2MSFTNGP04.phx.gbl...
>>> =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

Maybe Ardus is not English/American, it certainly looks like the equivalent
of the TEXT function to me


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com