View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default =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