TODAY

Returns the current date as a date value.

Sample usage

TODAY()

Syntax

TODAY()

Notes

• Note that TODAY is a volatile function and can impair 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 when 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 into a date value.

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

Examples

Returns the current computer system date.

Make a copy