NOW function

Description

The function NOW() takes no argument and returns the current date and time combined into one number. This number is the sum of the serial date number and the serial time number.

Note that the value of this function is not fixed and returns a different value each time the spreadsheet is recalculated.

Example

NOW() returned 77695.71806 on September 20, 2013 at 17:14 PM.

77695.71806 is the sum of DATEVALUE("20.09.2013") and TIMEVALUE("17:14")

Calculator

Related functions

• List of Date and time functions