TODAY

Returns the current date. The value is updated when the workbook is reloaded.

Sample Usage

TODAY()

Syntax

TODAY()

The function syntax has no arguments.

Examples

TODAY() returns the current date. 
TODAY()+5 returns the current date plus five days. 

Notes

  • TODAY is a volatile function and can hurt spreadsheet performance.
  • TODAY provides the current date with no time component. 
  • The TODAY function is updated whenever the workbook is reloaded and does not show the date when it was first entered.