Header

[Guest]

Is there a way in the custom header menu to use only the
YYYY format for the date rather than the entire date.

 

[Frank Kabel]

Hi
AFAIK you'll need vBA for this. e.g. put the following code in your
workbook module:
Private Sub Workbook BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In me.Worksheets
With wkSht.PageSetup
.CenterHead = Format(date,"YYYY")
End With
Next wkSht
End Sub