NOW formula is used to get the current system date and time. Whenever worksheet will be calculated, NOW formula will give updated date and time.
Syntax for NOW formula
NOW()
Parameter details:
NOW formula works without any parameter.
Returns
The NOW function returns a date value.