Kornilios Ampatzis/ April 25, 2019/ Functions

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:

Practice

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

Share this Post