Keep in mind for this formula to work, the workbook will need to have
already been saved. Otherwise, it returns #VALUE.


"John Bundy" (remove) wrote in message
...
If I understand correctly this should give you want you want and you can
perform calculations with the result, if anybody knows a cleaner method
I'm
all ears!
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Boyd Parks" wrote:

I am trying to create a workbook with 52 sheets, one for each week in a
year. There needs to be a column for each day of the week on each sheet.
I
want the Friday's date to appear as the tab's value on each sheet. And
finally, I want to be able to use &[Tab] in the heading. Ideas?