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