NOW

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

Sample Usage

NOW()

Syntax

NOW()

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.