Does anyone know how I can display the created on date in a cell of the
spreadsheet? Thanks in advance

Put this in a Standard module:

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

and use =crdate() in the worksheet.

Modify this to suit
MsgBox ThisWorkbook.BuiltinDocumentProperties("Creation Date")

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Marie Bayes" wrote in message
...
Does anyone know how I can display the created on date in a cell of the
spreadsheet? Thanks in advance

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.

Thanks

"John Bundy" wrote:

Modify this to suit
MsgBox ThisWorkbook.BuiltinDocumentProperties("Creation Date")

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Marie Bayes" wrote in message
...
Does anyone know how I can display the created on date in a cell of the
spreadsheet? Thanks in advance