Return the current date, updated automatically each day.
Syntax
TODAY()Arguments
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()→2026-06-18Returns today's date.
=A2-TODAY()→12Days remaining until a due date in A2.
Type the function
Enter =TODAY() — it takes no arguments.
Subtract for durations
Use date − TODAY() to get days remaining or elapsed.
It's volatile by design — it always shows the current date. To freeze a date, type it or paste the result as a value.