Returns the current date
Syntax:
TODAY()
returns the current date (as a date-time serial number). TODAY is updated at every recalculation, for instance if a cell is modified.
Example:
TODAY()
when calculated at say 12 noon on 1 Dec 2021 returns 1 Dec 2021.