Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter due this Week ,next week, nextweek
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! "Excel" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter due this Week ,next week, nextweek
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 "akphidelt" wrote: 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! "Excel" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
group sales by week and week number | Excel Discussion (Misc queries) | |||
Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |