TODAY

Returns the current date, recalculated each time the workbook opens or recalculates. It takes no arguments but needs the brackets. Also in Lec 04.

When to use

Because it is volatile, results change every day and a saved file shows the values from its last calculation. Freeze a date by typing it or using DATE, and use it inside DATEDIF to measure time left to a date.

See Lec 03.

Appears in

No references yet.