NOW Function returns the serial number of the current date and time.
Formula:
= NOW()
Cautions:
- 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.