This is the formula I have which works with invoice due date compared to todays date.
=IF(J13="","",(IF((TODAY()-J13)>0,"Overdue","Current")))
J13 is the payment due date.
In cell K13 I have will input the actual payment date. Is there a way that one I have inputed data into K13 it will change the formula to say "Paid"
??
R.
Bookmarks