Date & Time
Modern
TODAY
Returns the current date.
Available in All versions
Syntax
TODAY()What it returns
Today's date, as a date.
Example
=TODAY()Important to know
Volatile — recalculates on every workbook recalculation, not only when its inputs change.
Date only, no time (use NOW for date + time).
For a fixed date, paste the result as a value.