Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

NOW function


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.


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")


NOW( )  

Related functions