Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to categorize to do list by date, please
In Excel 2003, I am trying to keep a "to do list", but I also want to assign
either a date (or none) for each item, and then have them show up in other sections, categorized by the date (or none) assigned. I would like to have them separated into different worksheets: 1. Worksheet 1: General list which includes all entries 2. Worksheet 2: "This week", includes sections for each day 3. Worksheet 3: "Next week" 4. Worksheet 4: Open dated etc... Please help! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to categorize to do list by date, please
For starters, try using autofilter on a helper, criteria col
which categorizes your input col .. Assuming your key inputs is in A2 down you could place something like this criteria into B2: = IF(A2="","",IF(A2="Open","Open dated", IF(WEEKNUM(A2,2)=WEEKNUM(TODAY(),2)+1,"Next week", IF(WEEKNUM(A2,2)=WEEKNUM(TODAY(),2),"This week", IF(WEEKNUM(A2,2)=WEEKNUM(TODAY(),2)-1,"Last week", "Out-of-range"))))) Entire criteria expression goes into B2, its "exploded" for easy understanding. Note the criteria presumes that other than input of real dates, the only valid text input made in A2 down will be the word: Open Copy B2 down to cover the max extent of inputs expected in col A, say down to B200. In use, just apply/use autofilter on col B to choose any category's subset that's desired. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "OCDinNC" wrote: In Excel 2003, I am trying to keep a "to do list", but I also want to assign either a date (or none) for each item, and then have them show up in other sections, categorized by the date (or none) assigned. I would like to have them separated into different worksheets: 1. Worksheet 1: General list which includes all entries 2. Worksheet 2: "This week", includes sections for each day 3. Worksheet 3: "Next week" 4. Worksheet 4: Open dated etc... Please help! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Categorize certain times of day as other days | Excel Discussion (Misc queries) | |||
Categorize Income and Expenses? | Excel Discussion (Misc queries) | |||
Want to Automatically Re-Categorize a Downloaded Internet Spreadsheet | Excel Discussion (Misc queries) | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
Categorize drop down list | Excel Worksheet Functions |