Copy worksheet name into cell in worksheet

[Guest]

I'm looking for a way to have the name of the worksheet I am working in automatically entered to a cell on the worksheet ie: Worksheet name is 1-1-03 this would automatically be entered into cell 2a of the worksheet and that would have formatting to show not only that date but also the day of the week that day is(1-1-04 Thursday) I have the cell formatted already but it is really over kill to have to manually enter this info both as the worksheet name and into this cell for every day I must enter.

 

[Norman Harker]

Hi Laura!

Use:

=--MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Format mm-dd-yy dddd

The file has to be saved before you can gram the sheet name using the
CELL function.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.