Documentation/How Tos/Calc: NOW function
From Apache OpenOffice Wiki
NOW
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 1Apr08 returns that date and time.