How do i change the date format in a footer?

  • Thread starter Thread starter Guest
  • Start date Start date
Whatever format is in the Windows Regional and Language Settings governs what
the format is in the header or footer.

These are very limited and Excel recognizes only a few for header formatting.

To get a header date format of your choosing use a cell reference for the
header.

e.g. In A1 enter =TEXT(DATE(2006,12,10),"dddd, mmmm d"&", "&"yyyy")

Then run this macro.

Sub CellInHeader()
With ActiveSheet
..PageSetup.CenterHeader = Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Footer date format 2
Custom footer date format 2
Footer date format 1
Changing date format in a footer 3
How do I add the last modified date to the footer in Excel? 1
How do I alter the date format in the footer in Excel? 1
Excel Unique last page footer 1
Date Stamp in Footer 1

Back
Top