| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting date in a cell referring to the tab sheet
I need to put the date into a cell which corresponds to the sheet tab which
is date Jan 09, Feb 09? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
putting date in a cell referring to the tab sheet
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 --------------- Jacob Skaria "Rachel" wrote: I need to put the date into a cell which corresponds to the sheet tab which is date Jan 09, Feb 09? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to a variable cell on another sheet | Excel Worksheet Functions | |||
| Putting computer date in cell | Excel Discussion (Misc queries) | |||
| Putting computer date in cell | Charts and Charting in Excel | |||
| Putting the date as a sheet name | Excel Discussion (Misc queries) | |||
| putting date and time together in 1 cell | Excel Discussion (Misc queries) | |||
Linear Mode
