TODAY Function: syntax, examples, mistakes and translation notes
Returns today’s date.
Syntax
=TODAY()
Worked examples
=TODAY()
Returns the current date according to the spreadsheet environment.
=TODAY()-A2
Returns elapsed days when A2 is a valid earlier date.
Practical tips
- TODAY is volatile in the sense that it changes as the date changes/recalculates.
- Store fixed reporting dates in cells when you need a reproducible historical snapshot.
- Use NOW when time-of-day is also required.
Common mistakes
- Expecting TODAY to remain fixed after the workbook is reopened.
- Subtracting a text-formatted date that was never converted to a real date value.
Related functions
Frequently asked questions
What does TODAY do?
Returns today’s date.
Why might a TODAY formula return an unexpected result?
Expecting TODAY to remain fixed after the workbook is reopened. Start by testing the smallest referenced range or condition independently before adding wrappers or fallbacks.
Check the complete formula
Function syntax is only one part of a working workbook. Paste the finished expression into the Formula Checker for structural warnings, the Formatter for readability or the Translator when a supported locale mapping is involved.
Testing note: examples are educational. Spreadsheet versions, locale settings, tables, named ranges and workbook data can change behavior, so validate important formulas with representative data.