Set font and date in footer

I'm trying to make a very simple Excel macro that will put the date on
the bottom left footer and make it a font of Ariel 8.

I've got the date part working OK with:
Sub UpdateFooter()
Active***.PageSetup.LeftFooter = Format(Date, "ddddd")
End Sub

HOWEVER, when I try to add something to set the font, such as

Sub UpdateFooter()
Active***.PageSetup.LeftFooter = "&8" & Format(Date, "ddddd")
End Sub ^^^^^^^^

- now it doesn't work. I get a gigantic date in bold format.

Any ideas on where I'm going wrong with this?? Thanks - J. Koskey

.