NOW
Formulas / NOWDisplays 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() - 7This will give the date and time for a week ago.
=NOW() + 7This will give the date and time for a week in the future.
=NOW() + 90This 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.
