TODAY

Returns the current date.

Syntax

TODAY( ) → Date

Remarks

This function returns the serial number of the current system's date. This only returns the date, without the time component. For the specific time of day as well, use the NOW function.

Example

Formula

=TODAY()
="The year is "&YEAR(TODAY())

See Also

Function Reference
DATE Function
TIME Function
DAY Function
NOW Function