[]
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.
If today is the 14th of November in the year 2003, then TODAY() gives the result 11/14/2003 12:00:00AM