Returns the current date and time. The value is updated when the workbook is reloaded.
The function syntax has no arguments.
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).
- 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.