Help w Today() + Text excel vba

[Musa15]

My code looks like this

ActiveCell.FormulaR1C1 = "CHARGES 03/23/15"

I would like to run my vba code daily for a daily report, so I need the macro to input something like "TODAY()" e.g. today's date.

How can I combine "CHARGES" with the date on the same cell? ty

 

[Jonmo1]

Try

ActiveCell.Value = "CHARGES " & Format(Date, "mm/dd/yy")

 

[Musa15]

Worked perfectly, ty