NOW

Formulas / NOW
Displays the current date and time

NOW()

Examples

=NOW()
The function returns the current date and time. This can be used to log the current time of day when a cell is changed or when a formula is run.
=NOW() - 7
This will give the date and time for a week ago.
=NOW() + 7
This will give the date and time for a week in the future.
=NOW() + 90
This will give the date and time for 90 days in the future.

This will give the date and time for 90 days in the future rounded to the nearest hour.

The NOW function is used to get the current date and time; it takes no arguments and updates when a worksheet is updated.

The NOW function returns a serial number representing the current Sourcetable date and time when used. The NOW function updates whenever the worksheet is updated.
The NOW function takes no arguments and should be used with empty parentheses.

What is the syntax for the NOW function?

The syntax for the NOW function is NOW().

Does the NOW function take any arguments?

No, the NOW function does not take any arguments.

What does the NOW function return?

The NOW function returns the serial number for the current date and time.

What is the NOW function used for?

The NOW function is useful when calculating values based on the current date and time.

Does the NOW function update automatically?

Yes, the NOW function updates whenever the worksheet is opened.

Drop CSV