TODAY

Returns the current date. This function is volatile - it generates a new value any time any cell in the workbook changes - but it doesn't recalculate automatically based on the workbook date. If the function doesn't return the value you expect, check the workbook time zone setting in File > About. The workbook inherits the time zone setting of the workbook creator. If needed, you can change the time zone value by navigating to File > Settings.