ExcelBanter - How do I enter the creation date in Excel, rather than current da.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I enter the creation date in Excel, rather than current da. (https://www.excelbanter.com/excel-worksheet-functions/10322-how-do-i-enter-creation-date-excel-rather-than-current-da.html)

How do I enter the creation date in Excel, rather than current da.

Function CreaDate() As Date
CreaDate = ActiveWorkbook.BuiltinDocumentProperties("Creation date")
End Function

Usage is: =CreaDate()

OR more options....

Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

Usage is:

=DocProps("last author")

=DocProps("last save time")

=DocProps("creation date")

Gord Dibben Excel MVP

On Thu, 27 Jan 2005 10:59:05 -0800, Tazman
wrote: