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