You'll need to create a user defined function.
Alt+F11 to get to VBA, then Insert Module.

Paste the following code:

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


You can then use the function in a workbook as follows:
=CreationDate()

However, you may notice it returns a number (like 40155), so you'll need to format the cell as a Date.


Cheers,
Rob


Thomas M. wrote:
Excel 2007

I have a need to insert the file creation date into a workbook. I could
swear that I've done this before, in earlier versions of Excel.
However, I'm not real familiar with Excel 2007 yet and I'm having a hard
time figure out how to do this. I went to the Formulas ribbon and then
to Insert Function and looked through the date and time functions, but
did not see what I need.

Is there a way to insert the file creation date into an Excel workbook?

--Tom