Part name part formula?

I have a thread which is ongoing about opening a file then a sheet with a part name.
Is there a way of making a formula like this?

I want a sheet opened which is called "3 Days 25.1.13" BUT the date will change weekly and the 3 days will always stay the same.
So in the macro I have "3 days & A1 value" (25.1.13)
But it's not working.

The formula in A1 is this:

Formula:

Please Login or Register  to view this content.

So the text now appears 25.1.13 HOW; if possible can i get the "3 days" incorporated before this formula starts? I tried using

Formula:

Please Login or Register  to view this content.

and other combination types, but it wont recognise this?

I dont mind using 2,3 or more cells to get the final combination somehow, so then in my macro I can then say A1 value which i'm hoping to be read as
"3 days 25.1.13"

Thanks

Any of these are great!
I can just change the format of how the tabs are written to suit the date!
Thanks guys.