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


Returns current date and time.


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.




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

Returns the serial number of today’s date.


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 »
Return date by combining Hour, Minute and Seconds in Excel


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


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 »