View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kev
 
Posts: n/a
Default =IF((TODAY()-B8)30, "Overdue", "Current"),

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.