You can't put a function or formula in a header or footer. In
your case, you can use VBA code to set the Left/Center/Right
Header/Footer to the last save date.

ActiveSheet.PageSetup.CenterHeader = _
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"KHNorton" wrote in message
...
Is it possible to use a function in a header or footer? I'd
like to be able
to include the date the file was last saved.

Thanks!