How to Use NOW Function

NOW Function returns the serial number of the current date and time.


= NOW()


  • The results of the NOW function change only when the worksheet is calculated or when a macro that contains the function is run.
  • Numbers to the right represent the time; numbers to the left represent the date.
  • "NOW()" returns to the current date and time; "NOW()-1" returns the date and time one day earlier.

Download: NOW Function

Leave a Reply