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