Quick Navigation

TODAY Function

Excel 2007+

Summary

The TODAY function returns the current date as a serial number, automatically updating whenever the workbook recalculates. Excel automatically formats the result as a date, making it perfect for dynamic date displays, age calculations, and time interval computations.

Syntax

TODAY()

Using the TODAY Function

TODAY() is essential for creating dynamic spreadsheets that always reflect the current date without manual updates. Use it in combination with other date functions to build aging reports, deadline trackers, and automated reporting systems.

Common TODAY Examples

Get Current Date

=TODAY()

Displays today's date, automatically formatted by Excel.

Calculate Age

=YEAR(TODAY())-1963

Calculates age based on birth year 1963 using current year.

Days Until Deadline

=DATEVALUE("1/1/2030")-TODAY()

Shows days remaining until January 1, 2030 (format cell as Number).

Days from Today

=TODAY()+5

Returns date 5 days in the future.

Frequently Asked Questions

Ensure calculation is set to Automatic: File > Options > Formulas > Calculation options > Automatic.

Dates are stored as serial numbers starting from January 1, 1900 as serial number 1.

TODAY returns only the date. NOW returns date and time.

Common Errors and Solutions

TODAY not updating

Cause: Manual calculation mode enabled

Solution: Set to Automatic calculation in Excel Options

Wrong date format

Cause: Cell formatted as text

Solution: Format cell as Date or General

Notes

TODAY recalculates every time the workbook recalculates
Use F9 to force recalculation
TODAY is volatile - recalculates frequently
Perfect for dashboards and reports

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+