To use this function, choose Calc > Calculator.

Returns the current date; for example, 12/5/2013. This function is useful in macros and formulas.

Syntax

TODAY()

Example

An accountant has a column of dates when an invoice was sent (C2) and wants to determine how long a bill has gone unpaid. The accountant enters the expression TODAY()–C2 and stores the results in C3.

C2-D C3
Invoice sent Days outstanding
2/13 130
4/23 60
1/17 157
5/22 31
6/4 18