Use filename as date

[srcasm83]

If the file name of a spreadsheet is 01-10-09.xls, is there a formula to use the file name as the date in any given cell? I tried =CELL("filename") but that gives the whole path, and all I need is the numbers so that the date will show up in this cell in dddd, mmmm dd, yyyy format. Any help is appreciated!

 

[DonkeyOte]

Assuming the fact that you are use a consistent naming convention on the file names (mm-dd-yy) perhaps:

=DATEVALUE(MID(CELL("filename"),FIND(".xls",CELL("filename"))-8,8))
you could of course hold CELL("filename") in one cell and refer to that cell in the above as opposed to repeating the function in the above formula.

Then given the result is a date you can apply a Custom Format of on the cell as you detail.

Hope that helps.

 

[srcasm83]

That worked perfectly. And yes, the filename is always in mm-dd-yy format. Thanks so much!