Thursday, November 8, 2012

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