Cell C2 contains a date in this format: 7/23/2006

How can I convert that date and place it in this file path
automatically, I put the result I need in bold?

='C:\Documents and Settings\PC\My Documents\Green
Books\[GB_*072306*-Q6150.xls]DailyWS'!$D$5

Thank you,
Em


--
Emma317
------------------------------------------------------------------------
Emma317's Profile: http://www.excelforum.com/member.php...o&userid=36598
View this thread: http://www.excelforum.com/showthread...hreadid=563417