Formatting the Date in Header/Footer

  • Thread starter Thread starter stak
  • Start date Start date
S

stak

Hi

When using the Date tab in either the header or the
footer, the date is displayed as: 21/11/03.

Is there any way to insert a custom date into the header.
I have to insert the date as: 21 November 2003.

I have tried: &(Date/dd mmmm yyyy) but no such luck.

Any help would be most welcome.

Thanking you in advance.

Regards
Sue
 
I think you'll need a macro:

Right click on the Excel Icon to the left of the worksheet menubar
(File|edit|View...) and select view code:

Paste this in:

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Worksheets("sheet1").PageSetup
.LeftHeader = Format(Date, "dd mmmm yyyy")
End With
End Sub

Adjust the worksheet name & header section accordingly.

(I'd record a macro when doing it once manually to get the spelling correct.)
 
Back
Top