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