What is the TODAY Function
The TODAY function returns the current date and updates automatically every time the workbook recalculates. It is useful for age calculations, for due date tracking, and for dynamic report dates.
Formula: =TODAY()
Practical Example 1
Type =TODAY() in any cell.
Result: the current date, such as 17-Oct-2026
Practical Example 2
Add 30 days to today.
Type: =TODAY() + 30
Result: the date 30 days from now
Practical Example 3
Calculate age using DATEDIF and TODAY.
Type: =DATEDIF(A2, TODAY(), Y)
Result: the age in years
Practical Example 4
Build a dynamic report header.
Type: =Report as of & TEXT(TODAY(), dd-mmm-yyyy)
Result: Report as of 17-Oct-2026
When to Use It
TODAY is used for age calculation, for due date tracking, for dynamic report headers, for calculating days remaining, and for any formula where the current date should update automatically.