R Rachel Nov 6, 2009 #1 I need to put the date into a cell which corresponds to the sheet tab which is date Jan 09, Feb 09?
J Jacob Skaria Nov 6, 2009 #2 Hi Rachel Try the below in a saved workbook =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") Also try the below and format to excel date format =DATEVALUE(REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")) If this post helps click Yes
Hi Rachel Try the below in a saved workbook =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") Also try the below and format to excel date format =DATEVALUE(REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")) If this post helps click Yes
