I want to create a sheet that I can collate data gathered from the net for
release dates of books, dvd's etc... I will not be doing this on a regular
basis,just when something catches my eye.

Can I create a formula to tell me when the sheet was last edited and last
edited when I open it up.

Thanks
John

Hello,
Check out http://www.rondebruin.nl/print.htm#Last

For the "last saved date" here is what you want:

Format(ThisWorkbook.BuiltinDocumentProperties("Las t Save Time"), "yyyy-
mmm-dd hh:mm:ss")


HTH,
JP


On Nov 6, 6:05 pm, "JF" wrote:
I want to create a sheet that I can collate data gathered from the net for
release dates of books, dvd's etc... I will not be doing this on a regular
basis,just when something catches my eye.

Can I create a formula to tell me when the sheet was last edited and last
edited when I open it up.

Thanks
John