Formula for automatic title

Hey everyone,

My English isn't very well so i'm gonna try to make you guys understand my question.
I have a workbook with lots of data and graphics.
Now my question is if someone knows how you can add an automatically title for the graphic.
Is there some formula or something? I was thinking about a message box that writes it to the title, but i'm a bit stuck with how to do it.
Or can you make it work by using hidden fields or with the date of today.
It should be with months. Some text needs to stay but the month should be changed.
Like now it is the 29th of November then in the title should be texttexttexttex November texttexttext ...
When it is the first of December there shoul be texttexttext December texttexttext.
Is this possible or not ?

Kind regards and thanks a lot

I get immediately errors when I type the formula.
I typed the formula in a cell like you told -
= "Aging open Calls "&TEXT(TODAY(),"MMMM")
Could you tell me what i put wrong in the formula ?
Thnx

I copied the formula of the file that was posted here and now it is working.
But it's not what they were looking for. You guys helped me with my question but i understood it wrong.
I thought it would be easier if the month would be automatically, but now they say that if someone is sick that should make that document and she should make it from 2 months that the month isn't correct anymore.
Like when she wants to make in December the printscreens of the Graphics from November and December the month stays on December.
Does this change a lot to the formula or not ?
Thnx

Is it possible that you have a list on the homepage and that you just need to select the month and it changes automatically in th formula ?

Ok thnx i'm gonna try it

Thnx a lot guys you helped me a lot ! It works and everyone is happy