is it possible to display the ONLY the year in the Header/footer? if any body
knows that would be great

You could type it in.

Or you could use a macro...

Option Explicit
Sub testme01()
With Worksheets("Sheet1")
.PageSetup.CenterHeader = Year(Date)
'any more stuff
End With
End Sub

KWhamill wrote:

is it possible to display the ONLY the year in the Header/footer? if any body
knows that would be great

--

Dave Peterson

Why not just type 2010 in a custom footer?

You cannot format &Date without using VBA

Sub YearInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "yyyy")
End With
End Sub


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 08:04:01 -0800, KWhamill
wrote:

is it possible to display the ONLY the year in the Header/footer? if any body
knows that would be great