It returns the serial number of the current date and time.
The syntax of the function is the following:
NOW()
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here are two examples of how to use the NOW function:
Format the cell range B1:B10 so that numbers are displayed with 4 decimal places and a thousand separator. Then insert the appropriate function in this cell range to display the difference in days between the date in column A and the current date and time
Insert the appropriate function in the cell A1, to return the current date and time. Insert the appropriate function in the cell A2, to return the current date and time increased by 4 days (+ 4 days). Insert the appropriate function in the cell A3, to return the current date and time increased by 365 days (+ 365 days).