Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

TODAY function


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


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

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


TODAY( )  

Related functions