Cell Formatting when referencing worksheet name

I was reading through another thread regarding how to reference the name of a worksheet in a cell within that worksheet: http://www.excelforum.com/excel-gene...ml#post2594041

I am also wondering... my worksheet names are actually dates (Ex. 12-1-11)

I used the formula given: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

and it worked perfectly to reference the worksheet name into a cell of my choice.

Now, if only I could format this date to show up as Thursday, December 1, 2011 instead of 12-1-11...

Any suggestions?