TODAY Function in Excel Tutorial

Excel Tutorial

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.

PartMeaning
=Starts the Excel formula
TODAYFunction 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 FormulaCurrent 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

EmployeeJoining Date
Amit01-Nov-2026
Neha15-Oct-2026
Rahul20-Sep-2026

Assume joining dates are in B2.

Excel Formula

=TODAY()-B2

Expected Result

Assuming today’s date is 06-Nov-2026:

EmployeeJoining DateDays Since Joining
Amit01-Nov-20265
Neha15-Oct-202622
Rahul20-Sep-202647

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

CustomerDue Date
Customer A10-Nov-2026
Customer B20-Nov-2026
Customer C30-Nov-2026

Assume due dates are in B2.

Excel Formula

=B2-TODAY()

Expected Result

Assuming today’s date is 06-Nov-2026:

CustomerDue DateDays Remaining
Customer A10-Nov-20264
Customer B20-Nov-202614
Customer C30-Nov-202624

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

EmployeeBirth Date
Amit01-Jan-2000
Neha15-Jun-1998
Rahul20-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

CustomerDue Date
Customer A01-Nov-2026
Customer B10-Nov-2026
Customer C05-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:

CustomerDue DatePayment Status
Customer A01-Nov-2026Overdue
Customer B10-Nov-2026Not Overdue
Customer C05-Nov-2026Overdue

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

CustomerLast Purchase Date
Amit01-Nov-2026
Neha25-Oct-2026
Rahul15-Oct-2026
Priya30-Oct-2026

Assume purchase dates are in B2.

Excel Formula

=TODAY()-B2

Expected Result

Assuming today’s date is 06-Nov-2026:

CustomerLast Purchase DateDays Since Purchase
Amit01-Nov-20265
Neha25-Oct-202612
Rahul15-Oct-202622
Priya30-Oct-20267

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

EmployeeContract End Date
Amit10-Nov-2026
Neha25-Nov-2026
Rahul15-Dec-2026

Assume contract end dates are in B2.

Excel Formula

=B2-TODAY()

Expected Result

Assuming today’s date is 06-Nov-2026:

EmployeeContract End DateRemaining Days
Amit10-Nov-20264
Neha25-Nov-202619
Rahul15-Dec-202639

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

CustomerInvoice DateDue Date
Customer A01-Oct-202605-Nov-2026
Customer B10-Oct-202610-Nov-2026
Customer C15-Oct-202620-Nov-2026
Customer D20-Oct-202601-Nov-2026
Customer E25-Oct-202630-Nov-2026

Your Challenge

  1. Display today’s date at the top of the report.
  2. Calculate the number of days remaining until each payment due date.
  3. Identify payments whose due dates have already passed.
  4. Identify payments that are still due in the future.
  5. 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.