How do I alter the date format in the footer in Excel?

[Guest]

Whenever I set a date in the footer of Excel 2007, I get the SAME type of
format, i.e. "mm/dd/yyyy". The machine shows something like, say, "10/9/2007".

I want to change this to show soething like: "Tuesday, October 9, 2007"

Or evef, : "Tue, Oct 09, 2007".

How can I get this done ?

 

[Gord Dibben]

The date Excel places in headers and footers depends upon the Regional Settings
Date and you are limited to only a few variations.

I prefer a macro.

Sub DateInFooter()
ActiveSheet.PageSetup.RightFooter = Format(Date, "dddd, mmmm dd, yyyy")
End Sub


Gord Dibben MS Excel MVP