Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
close form code | Excel Discussion (Misc queries) |