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