How to use now function in excel

If you want to fill the current time in a certain cell in an Excel worksheet, use the = NOW function. First, move the cursor to any cell and then type the syntax = NOW (). The convenience of this function is that it doesn’t require any parameters inside parentheses. The result is the current time on the computer system.

Syntax: =NOW()

  • The NOW function syntax has no arguments.

Example 1: To do that, we need to just insert the formula =NOW() in the cell where the current date and time should appear.

Syntax: =NOW()

Result:

Excel NOW functio - How to use now function in excel

Example 2: To do that, we need to just insert the formula =NOW() in the cell where the current date and time should appear.

Syntax:

  • Now: =NOW()
  • Last week this time: =NOW() – 7
  • Next week this time: =NOW() + 7

Result:

excel now function 1 - How to use now function in excel

Above, we have shown you how to use the NOW function in Excel through the Illustrations, you already know how to apply the NOW function to calculations on spreadsheets.

Add a Comment

Your email address will not be published. Required fields are marked *