Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

NOW

Returns current date and time in Excel.
Returns the serial number of the current date and time.

Rational

Returns current date and time.

Description

The Excel NOW function returns the serial number of the current date and time. Example; to show the current date and time in Excel automatically, use NOW(), empty parenthesis.
The NOW function is helpful to extract the time taken to complete a project, compare time difference for a logical application of return value.

Syntax

=NOW()

Parameters

(Empty Parenthesis)

Return Value

Current date and time

Key Notes

  • The Excel NOW returns the result with no arguments. The NOW function provides not just the current time, but also the current date.
  • The NOW function update every time a user opens or change in the worksheet. The cell can also update every time using keyboard shortcut F9 or F2+Enter.
  • The NOW function is a volatile function that updates automatically once workbook is refreshed or open.
  • By subtracting a current date from NOW function using the TODAY function, we can find the current time =NOW()-TODAY(). Shortcut to enter the current timestamp is ‘Ctrl + Shift + :’, the resulting value is static (It does not change).

Keep Reading Similar Functions:

Return date by combining Hour, Minute and Seconds in Excel

TIME

The TIME function returns the time value by merging the three-time components. Example, use =TIME(9,15,35), that may returns “09:15:35”.

Read More »
Get a date by entering the year, month, and day in Excel

DATE

The DATE function returns a date value using year, month and date, sequentially. I.e.; to merge all 3 date component, =DATE(2012,12,4) returns “04-12-2012”.

Read More »
Returns the serial number of today’s date.

TODAY

The Excel TODAY function returns the current date in the selected cell. Example; to show the current date in Excel automatically, use TODAY(), empty parenthesis.

Read More »