PowerShell Script. Trying to use Formula & String in Naming Tab

[Benzula]

So I need to be able to name an Excel Tab the Current Year * 100 + Current Month + the text "(OSC)" for a result of this month being

201705 (OSC)

$ExcelWorksheet.Name = (get-date).Year * 100 + (get-date).Month ----- This Gives me the 201705


$ExcelWorksheet.Name = '(OSC)' ---- This Gives me the '(OSC')

$ExcelWorksheet.Name = (get-date).Year * 100 + (get-date).Month + ' (OSC)' ----- This gives me an error. I am assuming because it is trying to add instead of concatenate.

 

[AntMonkeyonJuice]

[COLOR=#333333][FONT=&quot][SIZE=1][COLOR=#ff4500]$ExcelWorksheet[/COLOR][/SIZE][/FONT][/COLOR][COLOR=#333333][FONT=&quot][SIZE=1][COLOR=#a9a9a9][SIZE=1][COLOR=#a9a9a9][SIZE=1][COLOR=#a9a9a9].[/COLOR][/SIZE][/COLOR][/SIZE][/COLOR][/SIZE][/FONT][/COLOR][COLOR=#333333][FONT=&quot][SIZE=1][SIZE=1]Name = [/SIZE][/SIZE][/FONT][/COLOR]get-date -format yyyyMM' (OSC)'