Returns the current date as a date value.
TODAYis a volatile function and can impair spreadsheet performance.
TODAYprovides the current date with no time component. To create a date with the current time, use
TODAYwill always represent the current date when the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered.
NOW: Returns the current date and time as a date value.
DATEVALUE: Converts a provided date string in a known format into a date value.
DATE: Converts a year, month and day into a date.
Returns the current computer system date.