=IF((TODAY()-B8)30, "Overdue", "Current"),
Use an extra column in that same row?
=if(x8="paid","",yourformula)
Kev wrote:
I have used this formula to set up an invoice tracker.. My question is how
do I make the formula know when an invoice has been paid.
--
Dave Peterson
|