TODAY function

Description

The function TODAY() takes no argument and returns today’s date. Note that the value of this function is not fixed, so if you use this function in a file and you reload this file the next day, the function will return the new date

Example

TODAY() returns 01.24.1998 if today is the 24^th of January 1998 and the date format is MM.DD.YY.

DATEVAL(TODAY()) returns the serial number of today’s date.

Calculator

Related functions

• NOW function: returns current date and time
• List of Date and time functions