To use this function, choose .
Returns the current date; for example, 12/5/2013. This function is useful in macros and formulas.
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.
|Invoice sent||Days outstanding|