View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel Excel is offline
external usenet poster
 
Posts: 26
Default filter due this Week ,next week, nextweek

i have this data with Name of a person each person has a corresponding task
that
are due in a weekly basis.

my question is how can i have it viewed in a way
were i can have it seen that are due this week, due next week, 5 days
greater than next week,

Ex:
Name 1
Task 1 due on 11/5/2008
Task 2 due on 11/12/2008
Task 3 due on 11/3/2008
Task 4 due on 11/19/2008
Name 2
Task 1 due on 11/23/2008
Task 2 due on 12/12/2008
Task 3 due on 12/15/2008
Task 4 due on 12/26/2008
Name 3
Task 1 due on 11/9/2008
Task 2 due on 11/12/2008
Task 3 due on 11/22/2008
Task 4 due on 11/30/2008

thank you.