← Back to level 1
Level 1Next
TODAY
Returns the current date and updates automatically.
Syntax
=TODAY()Step-by-step explanation
- 1Use it for live dashboards and reminders.
- 2The date refreshes every day when the workbook recalculates.
- 3Pair it with DATE logic for deadlines and aging.
Common mistakes
Expecting it to stay fixed
Using it where a static date is required
Forgetting date formatting
Example table
A quick scenario to connect the syntax to the result.
| Current date |
Formula
=TODAY()
Result
Current date
Worked example
- 1This formula has no input table because it pulls the current date or time directly.
- 2Type =TODAY() in the cell where you want a live timestamp.
- 3Excel will show Current date or a current equivalent when recalculated.
Practice area
Insert the current date into the sheet.
Match against the syntax block above.