You'd need to use VBA. Put these in your workbook code module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Range("A1")
.Value = Date
.NumberFormat = "dd mmm yyyy"
End With
End Sub
Private Sub Workbook_BeforeSave( _
ByVal SaveAsUI As Boolean, Cancel As Boolean)
With Range("A1")
.Value = Date
.NumberFormat = "dd mmm yyyy"
End With
End Sub
adjust the range reference as desired. Note that this will put the date
in even if the user cancels the save or print.
If you're new to macros, see David McRitchie's "Getting Started with
Macros":
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In article ,
"Mark Sowerbutts" wrote:
Also, how about the "Last Printed" or "Last Saved" date saved to a cell in
the spreadsheet.