filter due this Week ,next week, > nextweek

E

Excel

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.
 
A

akphidelt

What you should do is restructure your list so that it looks like

Name---Task---Due Date

Name 1---Task 1---11/5/2008
Name 1---Task 2---11/12/2008
Name 2---Task 1---11/23/2008

This way you have 1 block of data. Now you can easily filter the due date
column, or even better you can create a pivot table and search whatever
criteria you fancy!
 
E

Excel

thanks! i got your point but if i be using a conditional formating to which i
want to
have it shaded in different color -

Example:

if due date is with in this week color RED:
if Due date is with in next week color orange:
if due date is with in 7 days a head on next week due color green:

i find it difficult to create a formula hope you could help me
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top