TODAY (current date) |
  
|
TODAY (current date) |
|
Syntax:
TODAY()
Description:
This returns the current system date (without time).
The displayed value is dynamic, so it is automatically updated when the document is opened.
Note:
The result is a number – like all dates in a spreadsheet. Calculate automatically formats it in the date format MM.DD.YYYY so that it will be displayed as a date. You can use the options from the ribbon tab Home | group Number
to adjust the displayed date format to your needs.
Example:
TODAY() results in 07/31/2018
See also: