use concatenation by joining fragments of text and formulas
="'C:\Reports\Trial Balances\[Trial Balance
"&text(A3,"yyy-m-dd")&.xls]"


--
SLAnt
------------------------------------------------------------------------
SLAnt's Profile: http://www.excelforum.com/member.php...o&userid=34184
View this thread: http://www.excelforum.com/showthread...hreadid=539920