This function returns the date and time of the current date.
TODAY()
This function does not accept arguments.
If you use this function in a date-time cell (DateTimeCellType), the cell formats the value using the date format settings.
This function is updated only when the spreadsheet or cell containing the function is recalculated. This is a volatile function.
Does not accept data. Returns a DateTime object.
If today is the 14th of November in the year 2003, then
TODAY() gives the result November 14, 2003 12:00:00AM