TODAY

Returns the current date as a date value.

Sample Usage

TODAY()

Syntax

TODAY()

Notes

  • Note that TODAY is a volatile function and can hurt spreadsheet performance.

  • TODAY provides the current date with no time component. To create a date with the current time, use NOW.

  • TODAY will always represent the current date the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered.

See Also

NOW: Returns the current date and time as a date value.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the current computer system date.

Make a copy

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false