TIMESTAMP FORMULA

  • Thread starter Thread starter Stross002
  • Start date Start date
S

Stross002

Hello,

I want to put in cell A1 when I updated my worksheet.

I want it to read: "Last Updated: 4/15 at 1:04PM"

Please help!
 
hi
there isn't a formula that will do this. you might do better to use a macro
to insert the date/time.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = _
"last Updated: " & Now
End Sub

change the sheet name above is needed.
paste the above into the ThisWorkbook module. then each time you save the
file, the date and time will automaticly be inserted into the sheet you name
and cell A1.

to install...
press Alt+F11 to bring up the VB editor.
far left, expand your project(file)
expand excel objects.
double click ThisWorkbook
Paste the above into the code window(far right).
close the VB editor, save the file.

regards
FSt1
 
Back
Top