Convert Serial Number to Date WITH TEXT

Hello,
I know one can convert a serial number to a date by using formatting, but I am needing this to be done b/c the serial number is concatenated with some text (the word week i.e.
1/3/11 Week). However, I did try to format the cell but Excel keeps the date as a serial number.
The other half of my issue is I need to do this for a whole year of dates in a specified range and I was wondering if someone could give me an example of a macro I'd write up to basically change the bolded cells in the attached workbook to this format: m/d/yy along with the word 'week' concatenated to it and for these cells to refer to the first cell in the cells that precede it. Like I said, see the attached workbook to get a clear understanding of what I am trying to do. Thnx.

-HP RodNuclear