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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 ?
 
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
 
Back
Top