NOW

Formulas / NOW
Displays the current date and time
=NOW()
  • The NOW function does not have any arguments.

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.


Summary

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.

Frequently Asked Questions

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV