Inserting a worksheet name into the worksheet

[Guest]

Is it possible to reference a worksheet name in a cell of the worksheet?
When you do this in a header it reads &[Tab], but I can't work out how to put
it into a cell.

I want to do this for a timesheet spreadsheet that has the tab names as
dates and a cell on the worksheet that needs the date too. I always forget
to update the date cell when I create a new worksheet for a new week.

Thanks,
brett

 

[Vito]

Try this formula pasted in the sheet:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255

 

[Gord Dibben]

Just an added note here......

the workbook must have been saved prior


Gord Dibben MS Excel MVP