File name as number in workbook?

[bajra]

Just curious if this would be possible. I ran across how to get the filename to show up in a cell, with the following formula. Which dispalys "filename.xls"
Now i was wondering if i could get it to display with out the .xls bit.

My idea is to name the excel sheet for a given date- such as 5-13-11.XLS, then i have some date fields based off that (basically add a week to for each date field) I know it's not very practical i can just go into the sheet itself and enter a date off in a linked cell. I just wonder if it is possible


<code>=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)</code></pre>

 

[Smitty]

Welcoem to the Board!

You can use:

=MID(CELL("FILENAME",A1),FIND("[",CELL("FILENAME",A1))+1,FIND("]",CELL("FILENAME",A1))-FIND("[",CELL("FILENAME",A1))-5)

HTH,