& reference answering as Date Serial # not actual text
 

Hi all, TIA..
I'm trying to reference a user defined date in B4, it's
formatted "MMM dd, yyyy" in C8 i'm trying to use:

="["&$B$4&"]"&$C$8 to have it pull from another sheet
named by date, ie: Nov 25, 2004.xls, hence why i
formatted B4 as MMM dd, yyyy. The issue is that it
returns the date serial number instead of the entered
text, so the answer is [38316] instead of the text. The
user would like to enter a date to look up and have Excel
return the appropriate days' responses. If there's an
easier way to pull this, i'm all ears! :-)

Thanks again,
Kevin M