code for orders

R

recipe type data

i am useing excel 2000 and i want to enter all my customer orders on a work
sheet and i can use this code to filter for past due
invoices.="<"&today()-n1.my ? is what can i add to this code so that it will
ignore old paid invoices.thanks for your time.
 
R

Roger Govier

Hi
Just a little difficult without knowing the layout of your data, but
supposing that Column D hold Invoice date and column E holds Payment
Date, then the following should work

=AND(E1="",D1<Today()-N1)
Any invoices that are paid will have entries in Payment Date hence would
be ignored.
Change references to suit your data.
 
Top