Add date or text to sheet name formula

[Guest]

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!

 

[Guest]

Two questions: How will you indicate the month (is the month contained in the
filename)? How will you indicate the year?

Regards,
Bill

 

[Guest]

Two questions: How will you indicate the month (is the month contained in the
filename)? How will you indicate the year?

Regards,
Bill