Morning all,
I have the following formula in cell B1 to return the Sheet Name as the cell valuewhich returns the correct value however I can not format it as a date. Each sheet in the workbook represents a workday with the naming convention 1-13, 1-14 etc.Please Login or Register to view this content.
How can I modify the formula to take the sheet name (1-13) and have it show in the cell as Wednesday, January 13, 2010?
Many thanks
Bookmarks