Using Excel, given a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the ...
... payment is due.
One way of providing a note could be with a formula like this on the place where you want the note to appear:
=IF(TODAY()+45>A1,"Warning: Payment is coming due","")
Change the reference from A1 to ...
There are no new answers.