TODAY Function in Excel
Beginner
Returns the serial number of the current date.
Syntax
=TODAY()Example
Use Case
Display the current date in a report.
Common Errors to Avoid
- Updates automatically every time the worksheet recalculates
- Returns date only, not time (use NOW for date+time)
- Can cause circular reference errors in certain formulas
Pro Tips
Useful for calculating age, days until deadline, or date differences. If you need a static date, use Ctrl+; instead. Combine with date functions like EOMONTH or EDATE for date calculations.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →