Quick Answer
TODAY Function
TODAY displays today's date, updating automatically when the workbook opens or recalculates.
✓ Excel✓ Google SheetsExcel All versions
Syntax
TODAY
()
Basic Example
Get today's date
=TODAY()Result7/7/2026
Returns the current date as a serial number formatted as a date.
Advanced Examples
Example 1: Calculate days until deadline
Project managementFind how many days remain until a deadline
=A1 - TODAY()Result: 15
Subtracts today's date from the deadline date in cell A1.
Example 2: Calculate age from birthdate
Personal informationCompute someone's age from their birthdate
=DATEDIF(A1, TODAY(), "Y")Result: 30
DATEDIF calculates the difference in years between birthdate and today.
How TODAY Works
TODAY returns the current date as a serial number (Excel date format). It updates automatically whenever the workbook is opened or recalculated.
1
Select output cell
Choose where the date should appear.
2
Enter formula
Type =TODAY().
3
Press Enter
The result shows today's date.
Important Notes & Limitations
TODAY returns only the date, not the time.
For date and time, use NOW() instead.
Download Practice File
TODAY
todayPractice TODAY with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the TODAY function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Related Tutorials
Frequently Asked Questions
Does TODAY update automatically?
Yes, TODAY updates whenever the worksheet recalculates or when you open the workbook.
Can I use TODAY in conditional formatting?
Yes, TODAY() is commonly used in conditional formatting rules.