code for orders
 

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.

code for orders
 

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.

--
Regards

Roger Govier


"recipe type data" wrote in
message ...
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.