<< Click to Display Table of Contents >> CREATEDATE (date the document was created) |
Syntax:
CREATEDATE()
Description:
This returns the date/time the current document was created.
Example:
If a document was created on 31st of July, 2018 at 4:03 PM, the following applies:
CREATEDATE() returns 07/31/18 4:03 PM
Tip: By selecting a suitable date format in the dialog box of the ribbon tab Home | group Number , you can determine whether only the date, only the time or both should be displayed.
Compatibility notes:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
See also: