Capture the Workbook Name
Mintman,
Try to wrap the formula they sent you in the DATEVALUE() function:
=DATEVALUE(MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1 ),FIND("[",CELL("filename",A1)))-FIND("[",CELL("filename",A1))-1))
HTH,
Conan
"Minitman" wrote in message
...
Hey David and Sloth,
Thanks guys. They both indeed return the text string for the file
name as you said. This maybe what I requested, it is,
unfortunately,
not seen as a date. Is there anyway to convert this string into a
fully functual date?
TIA
-Minitman
On Tue, 6 Dec 2005 11:56:02 -0800, "Sloth"
wrote:
=MID(CELL("filename"),1+FIND("[",CELL("filename")),FIND(".",CELL("filename"),FIND ("[",CELL("filename")))-FIND("[",CELL("filename"))-1)
the file must be saved at least once before this formula will work.
"Minitman" wrote:
Greetings,
I have a lot of workbooks with a date as a name (eg. 2004-08.xls
or
1999-03.xls). I would like to capture the date portion of this
name
with a formula in sheet 'Date' cell 'A4'.
Anyone have any ideas?
Your help is appreciated.
TIA
-Minitman
|