yogi_Delineate Names For Weekly Task Assignments From A Date_Name_Activity Table

                                           Google Spreadsheet   Post  #861
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 08, 2012
user awyatt said : (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/36sZR3-VR24)
finding days within a week 
is there a way to say "if cell X falls within week Y, include cell Z"?

i've got a sheet that has a log date as one of many data points. i need to be able to split the data up into weeks. if i need to do it manually with separate sheets i can, but i'd rather have a full month show at once, then split it into weeks in the reporting. let's say i've got dates in this particular week...

11/4 - john - walk the dog

11/4 - john - take out the trash

11/7 - james - walk the dog

11/11 - jill - clean the counters

in this example, i would want a spot which can differentiate weeks. this information would end up looking like this

11/4-11/10        11/11-11/17

john                   jill

john

james

is this possible?

------------------------------------------------------------------------------------

following is a solution to the problem