filter

R

recipe type data

i am working with excel 2000 and if i have all orders by customer on one work
sheet is there a way to filter orders that are 30days or more past due.thanks
for your help.
 
J

Jim May

From your table copy off the header "Orderdate" to an out of way place say
M1
In cell N1 enter 30
In Cell M2 enter ="< " & TODAY()-N1
Invoke from the Menu, Data Filter, Advanced FIlter;
Listrange should be your range of data including the header row
Criteria range M1:M2

Change N1 at will - to 60, 90, etc
HTH,
Jim May
 
Top