Return the current date, updated automatically each day.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
TODAY()TODAY returns the current date with no arguments and recalculates whenever the sheet updates. It's the basis for age, due-date, and days-elapsed calculations. For date and time together, use NOW.
=TODAY()Result: 2026-06-18
Returns today's date.
=A2-TODAY()Result: 12
Days remaining until a due date in A2.
It's volatile by design — it always shows the current date. To freeze a date, type it or paste the result as a value.