NOW

  • Updated

Returns the current date and time. The value is updated when the workbook is reloaded.

 

Sample Usage

NOW()

Syntax

NOW()

The function syntax has no arguments.

Examples

NOW() returns the current date and time. 
NOW()-0.5 returns the date and time from 12 hours ago (0.5 days ago).
NOW()+0.5 returns the date and time 12 hours into the future (0.5 days ahead).

Notes

  • NOW is a volatile function and can hurt spreadsheet performance.
  • NOW provides the current date and time. To create a date without the current time, use TODAY.
  • The NOW function is updated whenever the workbook is reloaded and does not show the time when it was first entered.