Textbox Copy

H

Hardy

I have two workbooks called September (One in a folder called Room bookings,
and one in a folder called Diary) In the workbooks there a worksheets
representing the date for the month (worksheet 1 equals the 1st). What would
be the best way to place the day date and month in each of the worksheets,
without having to manually input it?
 
F

Frank Kabel

Hi
try the following formulas in your sheets (use the formulas as
provided. Don't change 'filename'):
1. The day (that is the sheet name):
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

2. the month name (that is your workbook name):
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-5)

3. If you want a real date value which you can format, try the
following formula:
=--(RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("f
ilename",A1),1)) & "-" &
MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL
("filename",A1),1)-FIND("[",CELL("filename",A1),1)-5) & "-" "2004")
 
Top