Is there a way to set horizontal header/footer margins? Or, to set the color
of header/footer text? I need to shift a date in the right footer leftwards
about two spaces for it to align. When I type two spaces (or any number of
spaces) after the date in the footer, Excel trims them.

I tried inserting two Chr(32)s (spaces) after the date in VB but they were
still trimmed (the date is being placed in the footer using "&D" in VB, but I
have the same issue when I type the spaces directly after the date in the
footer).

Also found a couple ASCII characters I didn't have on my machine, and I
placed one after the two spaces. This succeeded in preserving the two
spaces, but when I opened the document on another machine the ASCII character
showed up, so I need another solution.

Placing the date in the center footer and inserting a bunch of spaces before
it to shift it rightward is not an option because the page number is in the
center footer.

Anyone know a way to shift text leftwards, or to set the color so I can put
some white characters after the date to 'shift' it over?