Related Function:

The NOW function returns a serial number representing the current date and time in Excel.

Syntax

=NOW()

Note: NOW takes no parameters but requires empty parentheses.

  • The value returned by NOW will continually update each time the worksheet is refreshed, e.g. each time a cell value is entered or changed. Use F9 to force the worksheet to recalculate and update the value.
  • If you need a static time that won’t change, you can enter the current time using the keyboard shortcut Ctrl + Shift + :

Examples

The following spreadsheet shows the Time function applied to different sets of values.

  A B C
1 Formula Result Notes
2 NOW() 7/27/2015 18:30 The current date and time.
3 NOW()-7 7/20/2015 18:30 The date and time 7 days in the past from the current date and time.
4 NOW()+7 8/3/2015 18:30 The date and time 7 days in the future from the current date and time.