Formatting Date in Excel Footer

[lzweifel]

Hello, I did come across a very old thread that spoke of this but was unable to find it exactly as I am looking for. I would like to format my date in the footer to read... Printed: Wednesday, January 5, 2022

Thank you so much for any help, it is very much appreciated!

 

[Joe4]

I believe the only way to add a custom formatted Date to the header or footer (without changing your entire system settings) is with VBA, like this:

Sub AddDateFooter()
    ActiveSheet.PageSetup.CenterFooter = "Printed: " & Format(Date, "dddd, mmmm d, yyyy")
End Sub

 

[lzweifel]

Okay, thank you... do I put the entire code in the footer section?

 

[Joe4]

No, you just put it in a General Module in VBA, and run it from there.
See here: Insert and run VBA macros in Excel - step-by-step guide - Ablebits.com

 

[lzweifel]

Sorry, I do not understand as I cannot enter as is.

 

[lzweifel]

Okay, and if I share the file with someone else, will it work for them?

 

[Joe4]

Sorry, I do not understand as I cannot enter as is.

See the edit (with the link) I made in the previous post.

 

[Joe4]

Okay, and if I share the file with someone else, will it work for them?

If you save the file after adding the VBA code, the VBA code will be saved to the file.
So they will be able to use it themself, as long as they enable the VBA code and then run it.

If you run it yourself before saving the file, it will already be there (and stay there), so they really probably wouldn't need to run it themselves (unless they add new sheets).

 

[lzweifel]

Perfect! Let me try!

 

[lzweifel]

Yes... this worked perfectly, except it is not styled correct... sorry, how do I change the font and size?