Header concatenation

[bknight]

I desire a header concatenation that would look like this
Text & Month/Year(current date.
I tried various combinations
="Weighted S & P " & format(@date()"mm,yy"
="Weighted S & P " & format(NOW()"mm,yy")
This was an attempt to add the date then i would struggle to format it Month/Year.
Both failed.

[bknight]

Close but no winner yet.
="Weighted S & P " & formatdate(NOW();mm/yy)

[HansV]

Do you want to do this in VBA, or interactively?

[YasserKhalil]

If you are using formulas try

Code: Select all

="Weighted S & P " & TEXT(NOW(),"mm/yy")

[bknight]

Thanks