File Creation Date Function

  • Thread starter Thread starter Magic
  • Start date Start date
M

Magic

I want to include on a excel spreadsheet the creation
date of the file. Does anybody know how to automatically
input the file's creation date.
 
Hi
you'll need VBA for this. Find below a UDF for this task:

Public Function Get_Creation_date() As Date
Get_Creation_date =
ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Function

Enter the following in your target cell:
=Get_Creation_date()
and format the result as date
 
Back
Top