Introduction
The TODAY function in Excel returns the current date automatically. You don’t need to enter the date manually. It is useful for attendance sheets, employee records, payment tracking, due-date reports, and daily business calculations.
In this tutorial, you will learn how TODAY works, why its result changes, and how to use it in practical Excel examples.
1. What Is the TODAY Function in Excel?
The TODAY function returns the current date according to your computer’s date settings.
For example:
=TODAY()
If today’s date is 6 November 2026, Excel displays:
06-Nov-2026
The result depends on the actual current date when Excel recalculates the formula.
Unlike a manually entered date, TODAY updates automatically. You don’t need to edit the formula every day.
2. TODAY Function Syntax
=TODAY()
The TODAY function does not require any arguments.
| Part | Meaning |
|---|---|
= | Starts the Excel formula |
TODAY | Function name |
() | Empty parentheses because no arguments are required |
Important: Do not enter a year, month, or day inside the parentheses. TODAY automatically retrieves the current date.
3. How Does the TODAY Function Work?
When you enter:
=TODAY()
Excel checks the current system date and returns that date in the selected cell.
For example:
| Date Formula | Current Date |
|---|---|
=TODAY() | 06-Nov-2026 |
When the date changes to the next day and Excel recalculates, the result updates automatically.
Does TODAY Update Automatically?
Yes. TODAY is a volatile function, which means Excel recalculates it when a recalculation occurs.
It normally updates when:
- You open the workbook and Excel recalculates formulas.
- You edit cells and Excel recalculates the workbook.
- You press F9 to recalculate formulas.
Remember: TODAY returns a changing date, not a permanently fixed date. If you need to store a date that should never change, enter a fixed date instead.
4. Practical TODAY Function Examples
Question 1: Display Today’s Date
Problem Statement
A company wants to display the current date in its daily report without entering it manually.
Excel Formula
=TODAY()
Expected Result
If the current date is 6 November 2026:
06-Nov-2026
Explanation
TODAY checks the current system date and displays it in Excel.
The result changes when the date changes and Excel recalculates the formula.
Concept Covered: Displaying the current date automatically.
Question 2: Calculate the Number of Days Since an Employee Joined
Problem Statement
An HR department wants to calculate how many days have passed since an employee joined the company.
Data
| Employee | Joining Date |
|---|---|
| Amit | 01-Nov-2026 |
| Neha | 15-Oct-2026 |
| Rahul | 20-Sep-2026 |
Assume joining dates are in B2.
Excel Formula
=TODAY()-B2
Expected Result
Assuming today’s date is 06-Nov-2026:
| Employee | Joining Date | Days Since Joining |
|---|---|---|
| Amit | 01-Nov-2026 | 5 |
| Neha | 15-Oct-2026 | 22 |
| Rahul | 20-Sep-2026 | 47 |
Explanation
- TODAY returns the current date.
- B2 contains the employee’s joining date.
- Subtracting the joining date from today’s date gives the number of elapsed days.
Concept Covered: Calculating elapsed days using the current date.
Question 3: Calculate Days Remaining Until a Payment Due Date
Problem Statement
An accounts department wants to find how many days remain before each customer payment is due.
Data
| Customer | Due Date |
|---|---|
| Customer A | 10-Nov-2026 |
| Customer B | 20-Nov-2026 |
| Customer C | 30-Nov-2026 |
Assume due dates are in B2.
Excel Formula
=B2-TODAY()
Expected Result
Assuming today’s date is 06-Nov-2026:
| Customer | Due Date | Days Remaining |
|---|---|---|
| Customer A | 10-Nov-2026 | 4 |
| Customer B | 20-Nov-2026 | 14 |
| Customer C | 30-Nov-2026 | 24 |
Explanation
The formula subtracts today’s date from the payment due date.
For Customer A:
10 November – 6 November = 4 days remaining.
Concept Covered: Finding the number of days until a future date.
Question 4: Calculate Employee Age in Days Since Birth Date
Problem Statement
An HR department wants to calculate how many days have passed since each employee’s birth date.
Data
| Employee | Birth Date |
|---|---|
| Amit | 01-Jan-2000 |
| Neha | 15-Jun-1998 |
| Rahul | 20-Mar-2002 |
Assume birth dates are in B2.
Excel Formula
=TODAY()-B2
Expected Result
The result is the number of days from each employee’s birth date up to today.
Explanation
TODAY returns the current date. Subtracting the birth date gives the total number of elapsed days.
This example calculates days, not age in completed years.
Concept Covered: Calculating elapsed time from a past date.
Question 5: Check Whether a Payment Due Date Has Passed
Problem Statement
An accounts team wants to identify payment records whose due dates are earlier than today’s date.
Data
| Customer | Due Date |
|---|---|
| Customer A | 01-Nov-2026 |
| Customer B | 10-Nov-2026 |
| Customer C | 05-Nov-2026 |
Assume due dates are in B2.
Excel Formula
=IF(B2<TODAY(),"Overdue","Not Overdue")
Expected Result
Assuming today’s date is 06-Nov-2026:
| Customer | Due Date | Payment Status |
|---|---|---|
| Customer A | 01-Nov-2026 | Overdue |
| Customer B | 10-Nov-2026 | Not Overdue |
| Customer C | 05-Nov-2026 | Overdue |
Explanation
The formula compares each due date with today’s date.
- If the due date is earlier than today, the result is Overdue.
- Otherwise, the result is Not Overdue.
A due date equal to today is also shown as Not Overdue.
Concept Covered: Comparing a date with today’s date.
Question 6: Calculate Days Since a Customer’s Last Purchase
Problem Statement
A sales team wants to identify how many days have passed since each customer made their last purchase.
Data
| Customer | Last Purchase Date |
|---|---|
| Amit | 01-Nov-2026 |
| Neha | 25-Oct-2026 |
| Rahul | 15-Oct-2026 |
| Priya | 30-Oct-2026 |
Assume purchase dates are in B2.
Excel Formula
=TODAY()-B2
Expected Result
Assuming today’s date is 06-Nov-2026:
| Customer | Last Purchase Date | Days Since Purchase |
|---|---|---|
| Amit | 01-Nov-2026 | 5 |
| Neha | 25-Oct-2026 | 12 |
| Rahul | 15-Oct-2026 | 22 |
| Priya | 30-Oct-2026 | 7 |
Explanation
The formula subtracts the last purchase date from the current date.
The result tells the sales team how many days have passed since each customer purchased something.
Concept Covered: Tracking customer activity using the current date.
Question 7: Calculate the Number of Days Until an Employee’s Contract Ends
Problem Statement
An HR department wants to calculate the remaining days before each employee’s contract end date.
Data
| Employee | Contract End Date |
|---|---|
| Amit | 10-Nov-2026 |
| Neha | 25-Nov-2026 |
| Rahul | 15-Dec-2026 |
Assume contract end dates are in B2.
Excel Formula
=B2-TODAY()
Expected Result
Assuming today’s date is 06-Nov-2026:
| Employee | Contract End Date | Remaining Days |
|---|---|---|
| Amit | 10-Nov-2026 | 4 |
| Neha | 25-Nov-2026 | 19 |
| Rahul | 15-Dec-2026 | 39 |
Explanation
TODAY returns the current date. Subtracting it from the contract end date gives the remaining number of days.
A positive result means the contract end date is in the future.
Concept Covered: Tracking upcoming contract end dates.
Student Practice Tasks
Try these tasks using the TODAY function.
Task 1: Display Current Date
Enter the TODAY function in a blank cell and display the current date.
Task 2: Employee Joining Report
Calculate how many days have passed since each employee joined the company.
Task 3: Payment Tracking
Calculate the remaining days until each customer payment is due.
Task 4: Attendance Report
Create a report that displays today’s date at the top of an attendance sheet.
Task 5: Contract Monitoring
Calculate the number of days remaining before each employee’s contract ends.
Final Student Challenge: Build a Payment Due-Date Report
An accounts department wants to monitor customer payment dates.
Customer Data
| Customer | Invoice Date | Due Date |
|---|---|---|
| Customer A | 01-Oct-2026 | 05-Nov-2026 |
| Customer B | 10-Oct-2026 | 10-Nov-2026 |
| Customer C | 15-Oct-2026 | 20-Nov-2026 |
| Customer D | 20-Oct-2026 | 01-Nov-2026 |
| Customer E | 25-Oct-2026 | 30-Nov-2026 |
Your Challenge
- Display today’s date at the top of the report.
- Calculate the number of days remaining until each payment due date.
- Identify payments whose due dates have already passed.
- Identify payments that are still due in the future.
- Check how the report changes when the current date changes.
Goal: Build a simple payment monitoring report using TODAY and date calculations.
Key Takeaways
- TODAY returns the current date.
- Its syntax is
=TODAY(). - It does not require any arguments.
- TODAY is a volatile function and recalculates when Excel recalculates.
- You can subtract dates to calculate elapsed or remaining days.
- TODAY is useful for payment tracking, employee records, attendance, and business reports.
- TODAY returns a date, not the current time.
- Excel stores dates as serial numbers, so the cell format controls how a date appears.
Frequently Asked Questions (FAQs)
1. What is the TODAY function in Excel?
The TODAY function returns the current date according to your computer’s date settings.
2. What is the syntax of the TODAY function?
The syntax is =TODAY(). It does not require any arguments.
3. Does TODAY update automatically?
Yes. TODAY recalculates when Excel recalculates the formula, such as when you open the workbook or press F9.
4. Does TODAY return the current date and time?
No. TODAY returns only the current date. It does not return the current time.
5. What is the difference between TODAY and a manually entered date?
A manually entered date stays fixed unless you change it. TODAY returns a changing current date when Excel recalculates.
6. Can TODAY calculate the number of days between two dates?
Yes. You can subtract one date from another. For example, =TODAY()-B2 calculates the days between the date in B2 and today.
7. Why does TODAY sometimes display a number?
Excel stores dates as serial numbers. Change the cell’s number format to Date to display it as a readable date.
8. Is TODAY a volatile function?
Yes. Excel recalculates volatile functions during recalculation, even when their referenced cells have not changed.
9. Can TODAY be used to identify overdue payments?
Yes. You can compare a payment due date with TODAY to check whether the due date has passed.
10. How can I insert a fixed current date instead of a changing date?
Use the keyboard shortcut Ctrl + ; to insert the current date as a fixed value.

