This form shows a list of unpaid bills. If the time between the date of issuance of the bill and the current date exceeds the deadline, the bill must appear
expired.
function = TODAY () returns the current date (see
= fx function bar in the figure), so each time you open the spreadsheet, the cell
D2 show the current day's date.
In
D3 , we put together the following formula:
= IF ($ D $ 2-A4> B4, "EXPIRED", "CURRENT") Signs $ fixed cell D2 to copy it to subsequent cells.
USERS
seen answer
Author: Claudio Sanchez