← Back to level 1
Level 1Level 1
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
Practice area
Insert the current date into the sheet.
Match against the syntax block above.