Need to categorize to do list by date, please

[OCDinNC]

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!

 

[Max]

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