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 |