TODAY
Returns the current date.
=TODAY()This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.
What the function does
Overview
Returns the current date.
The TODAY function returns the serial number of the current date based on the computer's system clock. Because it is a volatile function, it triggers a recalculation of the entire workbook every time any cell is edited or the file is opened. This makes it ideal for dynamic dashboards tracking time-sensitive metrics like days remaining until a deadline or age calculations. However, users should avoid using it for static timestamps, such as recording the date an order was placed, as the value will change when the file is opened on a future date. For static entries, use the keyboard shortcut Ctrl+; instead. When nesting TODAY within other functions, ensure the cell formatting is set to a Date format; otherwise, Excel might display the underlying serial number (e.g., 45000) instead of a readable date.
Quick reference
Syntax
=TODAY()Formula patterns
Examples
Calculate days remaining until a deadline
=A2-TODAY()Calculate current age in years
=DATEDIF(B2, TODAY(), "y")Determine if a task is overdue
=IF(C2 < TODAY(), "Overdue", "In Progress")Avoid these issues
Common Errors
Numeric Serial Number
Cause: The cell is formatted as General or Number, showing Excel's underlying date value (e.g., 45281) instead of a date.
Fix: Change the cell format to Short Date or Long Date via the Home tab in the Number group.
Dynamic Value Change
Cause: Using TODAY() to record a historical event, which then updates to the current date every day.
Fix: Use the static keyboard shortcut Ctrl+; or use Paste Special > Values to convert the formula into a permanent date.
Platform support
Compatibility
Source: Microsoft Support
Common questions
Frequently Asked Questions
Returns the current date.
Numeric Serial Number: Change the cell format to Short Date or Long Date via the Home tab in the Number group. Dynamic Value Change: Use the static keyboard shortcut Ctrl+; or use Paste Special > Values to convert the formula into a permanent date.