Hi, sorry to show my ingorance, what do you mean by put it in a standard
module? Thanks

"P Sitaram" wrote:

Put this in a Standard module:

Function Crdate() As Date
Crdate = ThisWorkbook.BuiltinDocumentProperties("Creation Date")
End Function

and use =crdate() in the worksheet.