NOW

Returns the current date and time, recalculated like TODAY. It takes no arguments but needs the brackets, and the stored value has a whole-number date part and a fractional time part.

When to use

Because it is volatile, a report using NOW changes whenever the workbook is reopened or recalculated. Use TODAY when you only need the date.

See Lec 04.

Appears in

No references yet.