| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add date or text to sheet name formula
This is only part of what I need -
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Sheet name is 30 (for the day of the month) Every month has a separate file and it has a sheet for every day of the month. I need to add the month and year to the cell so I can reference a chart title to it. September 30, 2006 I can't use the =now function because the report on the sheet is not done on the date of the sheet, i.e. September 30 report may not be done til October 2, but the chart title needs to say September 30. Thanks for the help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add date or text to sheet name formula
Two questions: How will you indicate the month (is the month contained in the
filename)? How will you indicate the year? Regards, Bill "laralea" wrote: This is only part of what I need - =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Sheet name is 30 (for the day of the month) Every month has a separate file and it has a sheet for every day of the month. I need to add the month and year to the cell so I can reference a chart title to it. September 30, 2006 I can't use the =now function because the report on the sheet is not done on the date of the sheet, i.e. September 30 report may not be done til October 2, but the chart title needs to say September 30. Thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Date formula that adds 7 days to a cell when sheet is copied | Excel Worksheet Functions | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
