yogi_Sort The Range Of Week Date Composites In Column C in Ascending Order

                                          Google Spreadsheet   Post  #924

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 12, 2012
user awyatt said:(http://productforums.google.com/forum/#!mydiscussions/docs/YU2mY6eQe3A)
recognizing date ranges 
i have a spreadsheet that logs various issues by date, then automatically counts each type by week and by month. i have it set up so that the week and month titles automatically generate, so that when i put in a new entry for a given week the heading is automatically created. example:

       Input page                                      Tabulation Page

      A             B                              A                        B             C

    Date        Issue                        Week                  Issue 1    Issue 2

12/10/2012  Issue 1           12/16/2012-12/22/2012        0            1

12/10/2012  Issue 1            12/9/2012-12/15/2012         2            1

12/11/2012  Issue 2

12/17/2012  Issue 2

the problem comes where gdocs doesn't recognize "12/9/2012-12/15/2012" as a date range. the first cell (which says 12/16/2012-12/22/2012) contains a formula (thanks to someone on this forum!) like =SORT(ArrayFormula(filter(unique(if('Input page'!$A$2:$A="","",'Input page'!$A$2:$A-weekday('Input page'!$A$2:$A)+1&"-"&'Input page'!$A$2:$A+(7-weekday('Input page'!$A$2:$A)))),unique(if('Input page'!$A$2:$A="","",'Input page'!$A$2:$A-weekday('Input page'!$A$2:$A)+1&"-"&'Input page'!$A$2:$A+(7-weekday('Input page'!$A$2:$A))))<>""))). this sort recognizes "9" as being greater than "1", instead of seeing that it is less than "16", thus throwing off the sort

is there a way to get gdocs to recognize this date range? if not, how might one work around this? the monthly side works until a changeover in year, then of course january takes over!

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

following is a solution to the problem

yogi_Get Names For Weekly Task Assignments For Specified Activity From A Date_Name_Activity Table

                                           Google Spreadsheet   Post  #864
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 09, 2012
user awyatt said : (http://productforums.google.com/forum/?zx=sa5238gcjnz7#!mydiscussions/docs/36sZR3-VR24)
the solution in this post supplements the solution I posted in response to a question by user a wyatt in my following blog post:
yogi_Delineate Names For Weekly Task Assignments From A Date_Name_Activity Table
http://yogi--anand-consulting.blogspot.com/2012/11/yogidelineate-names-for-weekly-task.html
---
https://docs.google.com/spreadsheet/ccc?key=0AhJ53dneUaMIdENXeHBPN1dIMlItNkZBRWYyRGNQcWc

there's the link for the working copy i'm messing with. the top is the automatic version with your formulas in it. i included a snapshot (fully manual) of what it would look like in the end

the ultimate goal in this case is to include names in the filter ONLY if the person walked the dog. thus in the manual copy at the bottom you see only three names entered, because the other entries did not walk the dog

does that help you enough? i know my explanations can be convoluted sometimes!

----------------------------------------------------------------------------------------
following is the solution to a bit more generalized problem in that one can specify the Activity for which the Name(s) need to be pulled for Weekly task Assignments

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