=TODAY()One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single TODAY formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
TODAY():
This function does not take any parameters. It returns the current date based on the system's date settings.
The TODAY function in Excel is a simple yet powerful tool that returns the current date. It does not require any arguments and updates automatically whenever the worksheet is recalculated or opened. This makes it particularly useful for time-sensitive calculations and reporting.
In simpler terms, the TODAY function helps you keep track of the current date without needing to manually enter it, making it easier to manage deadlines and time-related data.
Imagine you are managing a project timeline in an Excel spreadsheet, and you have the following data:
| Task | Start Date | End Date |
|---|---|---|
| Task 1 | 2023-01-01 | 2023-01-10 |
| Task 2 | 2023-01-11 | 2023-01-20 |
| Task 3 | 2023-01-21 | 2023-01-30 |
| Task 4 | 2023-02-01 | 2023-02-10 |
You want to find out which tasks are overdue based on the current date.
To check if a task is overdue, you would use the TODAY formula in conjunction with a logical comparison. For example, to check if Task 1 is overdue, you would use the following formula:
=IF(TODAY() > C2, "Overdue", "On Time")When you apply the formula, it checks if the current date is greater than the end date of Task 1. If today’s date is, for example, 2023-01-15, the output would be:
| Task 1 Status |
|---|
| Overdue |
Here, the task is considered overdue since the end date has passed.
The TODAY function is particularly useful for tracking deadlines, calculating age, or determining how many days are left until a specific date. It allows you to automate date-related calculations without manual updates.
Understanding how to use the TODAY function can significantly enhance your date management capabilities in Excel, enabling you to stay on top of important deadlines and timelines.
Happy tracking!
You have a table where Column A contains the dates of various project deadlines and Column B contains the status of each project (e.g., "Completed," "In Progress," "Overdue"). You can use the TODAY function to highlight projects that are overdue by comparing the deadline dates in Column A with the current date. This allows for effective project management and prioritization of tasks, ensuring that deadlines are met and resources are allocated efficiently without the need for complex date calculations.
Beyond the TODAY function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.