TODAY Function

Returns today's date, updated every time the workbook recalculates.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

Today's date (serial number)

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

TODAY returns the current date with no time attached. It takes no arguments — the brackets stay empty.

It's volatile: it updates whenever the workbook recalculates or reopens, which makes it ideal for countdowns, ages and overdue flags.

Syntax

=TODAY() Explain

This function takes no arguments — the brackets stay empty.

Examples

Example 1 — Days until each invoice is due

Subtract today from the due date. (These results assume today is 3/15/2026.)

ABC
1InvoiceDue dateDays left
2INV-1013/20/20265
3INV-1023/31/202616
4INV-1033/10/2026-5
=B2-TODAY() Explain

A negative number means the invoice is overdue. Format the result column as General or Number, not Date.

Example 2 — Overdue flag

Combine with IF.

=IF(B2<TODAY(), "Overdue", "") Explain

Example 3 — Age in whole years

DATEDIF counts complete years between a birth date and today.

=DATEDIF(B2, TODAY(), "Y") Explain

Common mistakes

  • The date I typed yesterday has changed. TODAY always shows the current date. To stamp a date that never changes, press Ctrl + ; instead.
  • The result looks like 46096. The cell is formatted as General. Format it as Short Date.

Notes

  • Shortcut: Ctrl + ; types today's date as a fixed value; Ctrl + Shift + ; types the current time.
  • Related functions: NOW, DATEDIF, NETWORKDAYS, WORKDAY.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.