How to Use the TODAY Function in Excel

Dates play a crucial role in many Excel workflows. Whether you are tracking deadlines, calculating aging reports, managing projects, or analyzing time-based data, Excel’s date functions help automate and simplify these tasks. One of the most commonly used and powerful date functions is the TODAY function.

The TODAY function allows Excel users to dynamically display the current date and perform calculations based on it. Unlike manually entering a date, TODAY updates automatically each time the worksheet recalculates or is opened. This makes it especially useful for dashboards, reports, reminders, and time-sensitive formulas.

In this article, we will explore how to use the TODAY function in Excel in depth. You will learn its syntax, behavior, practical examples, common use cases, limitations, and best practices. By the end, you will have a solid understanding of how to integrate TODAY into real-world Excel solutions.

Understanding the TODAY Function

What Is the TODAY Function?

The TODAY function returns the current date according to your system’s date settings. It does not require any arguments and always reflects the current day.

Each time Excel recalculates the workbook—such as when you open the file, edit a cell, or refresh data—the TODAY function updates automatically.

Basic Syntax

=TODAY()

That’s it. The TODAY function takes no arguments, which makes it one of the simplest functions in Excel.

What Does TODAY Return?

The function returns a serial number representing today’s date. Excel stores dates as numbers, starting from January 1, 1900 (or January 1, 1904, depending on system settings). The displayed date format depends on the cell’s formatting.

For example:

• Serial number: 45230
• Displayed as: 01/14/2026 (depending on regional settings)

TODAY vs NOW: Understanding the Difference

Before diving deeper, it’s important to distinguish TODAY from another commonly used function: NOW.

Example:

=TODAY()   → 01/14/2026
=NOW()     → 01/14/2026 17:42

Use TODAY when you only need the date, and NOW when time precision matters.

Formatting the TODAY Function Output

Excel may display the result of TODAY in different formats depending on cell settings. You can customize this easily.

Common Date Formats

• Short Date: 01/14/2026
• Long Date: Wednesday, January 14, 2026
• ISO Format: 2026-01-14

To change the format:

1. Select the cell containing =TODAY()
2. Press Ctrl + 1 (or Cmd + 1 on Mac)
3. Go to Number → Date or Custom
4. Choose or define your preferred format

Formatting does not change the underlying value, only how it is displayed.

Using TODAY in Date Calculations

The real power of the TODAY function comes from combining it with other formulas.

Calculating Days Between Dates

To calculate how many days have passed since a given date in cell A1:

=TODAY() - A1

This is commonly used in:

• Aging reports
• Overdue invoices
• Subscription tracking

Calculating Days Until a Future Date

If cell A1 contains a future date:

=A1 - TODAY()

This formula helps track:

• Deadlines
• Project milestones
• Event countdowns

Using TODAY with IF Statements

TODAY is frequently used inside logical formulas to trigger conditions based on the current date.

Example: Check If a Task Is Overdue

Assume:

• Due date in cell A1

=IF(A1 < TODAY(), "Overdue", "On Time")

This formula automatically updates daily without user intervention.

Example: Highlight Upcoming Deadlines

=IF(A1 - TODAY() <= 7, "Due Soon", "Not Urgent")

This checks whether a task is due within the next seven days.

Using TODAY with Conditional Formatting

One of the most practical uses of TODAY is in conditional formatting.

Example: Highlight Overdue Dates

1. Select your date range

2. Go to Home → Conditional Formatting → New Rule

3. Choose Use a formula

4. Enter:

   =A1 < TODAY()
   

5. Choose a red fill color

This creates a dynamic visual alert system that updates automatically every day.

Calculating Age Using the TODAY Function

TODAY is commonly used to calculate age from a date of birth.

Basic Age Calculation

If date of birth is in cell A1:

=YEAR(TODAY()) - YEAR(A1)

However, this method is not fully accurate because it does not account for whether the birthday has occurred this year.

Accurate Age Calculation

A better approach is:

=DATEDIF(A1, TODAY(), "Y")

This calculates the number of full years between two dates.

Using TODAY with DATEDIF for Time Analysis

The DATEDIF function pairs extremely well with TODAY.

Examples

• Years since hire date:

  =DATEDIF(A1, TODAY(), "Y")
  

• Months since subscription start:

  =DATEDIF(A1, TODAY(), "M")
  

• Days since last update:

  =DATEDIF(A1, TODAY(), "D")
  

These formulas are widely used in HR, finance, and analytics dashboards.

Using TODAY in Financial and Business Scenarios

Loan and Payment Tracking

You can use TODAY to calculate how long a payment is overdue:

=IF(TODAY() > A1, TODAY() - A1, 0)

This formula returns the number of overdue days.

Subscription Expiry Monitoring

=IF(A1 < TODAY(), "Expired", "Active")

This is useful for SaaS products, licenses, and service contracts.

TODAY and Volatile Functions

The TODAY function is classified as a volatile function.

What Does Volatile Mean?

A volatile function recalculates every time Excel recalculates anything in the workbook—even if the referenced cells haven’t changed.

Impact on Performance

• Small spreadsheets: No noticeable impact
• Large models with thousands of formulas: May slow performance

If performance is critical, consider using a static date entered manually or via VBA.

Freezing the Date Returned by TODAY

Sometimes you want today’s date once, not dynamically.

Method 1: Copy and Paste as Values

1. Enter =TODAY()
2. Copy the cell
3. Paste as Values

Method 2: Keyboard Shortcut

Press:

Ctrl + ;

This inserts the current date as a static value.

Common Errors and Mistakes

TODAY Showing a Number Instead of a Date

Cause: Cell formatted as General or Number

Solution:

• Change the cell format to Date

Incorrect Date Due to System Settings

TODAY uses your system’s date and regional settings. If your system date is incorrect, Excel will reflect that.

Best Practices for Using TODAY

• Use TODAY for dynamic reports, not historical records
• Combine with IF, DATEDIF, and conditional formatting
• Avoid excessive use in large spreadsheets
• Use clear formatting for better readability
• Document formulas so users understand automatic updates

Practical Example: Project Tracking Dashboard

Imagine a project tracker with:

• Start Date
• End Date
• Status

Status formula:

=IF(TODAY() < A1, "Not Started", IF(TODAY() > B1, "Completed", "In Progress"))

This single formula dynamically updates project status without manual input.

TODAY Function Limitations

• Cannot return time
• Depends on system clock
• Volatile function
• No customization of refresh frequency

Despite these limitations, TODAY remains one of Excel’s most useful date functions.

Conclusion

The TODAY function in Excel is a simple yet powerful tool that brings automation and intelligence to date-based calculations. By automatically returning the current date, it eliminates manual updates and ensures that reports, dashboards, and formulas stay accurate over time.

From calculating overdue tasks and tracking deadlines to building dynamic dashboards and financial models, TODAY integrates seamlessly with other Excel functions such as IF, DATEDIF, and conditional formatting. Understanding how it behaves, when to use it, and how to manage its volatility will help you build more reliable and professional spreadsheets.

Mastering the TODAY function is an essential step for anyone looking to improve their Excel skills and create time-aware, automated solutions.