Print

Print


Ok. I'm looking at your script as well. I get the same results. Even if you
change the date you get "4"
You can change it to whatever year month day you want and you still get 4.

I'll play with it a bit and let you know what happens.



On Thu, Mar 16, 2017 at 2:19 PM Brian Brumley <[log in to unmask]> wrote:

> Nic,
>
> The following would be the formula in a Google Spreadsheet:
>
> =countif(B2:B10, "Monday") ...with B2:B10 being the range for the day.
>
> Not too experienced on what looks like Java (from your example), I'm more
> of a Python guy.
>
> Good Luck!
> -Brian
>
> On Thu, Mar 16, 2017 at 2:01 PM, Phillips, Nic <[log in to unmask]>
> wrote:
>
> Hey Folks,
>
> I anyone out there proficient with Google Apps Scripts? I am having a
> problem with one that I'm working on and just can't seem to figure out
> where the issue is.  The script I'm referencing below can be viewed at:
>
>
> https://script.google.com/d/1kenzklXLu_yZz2ZAt_nhwx2nOL3wi407pzQl6incA-ay2sRVCzDNJkJG/edit?usp=sharing
>
> My goal is to use this script in a spreadsheet to calculate how many
> instances of a particular day are remaining in the current month and return
> it as a numeric value.  For example, as of today, there are exactly 2
> Mondays remaining in this month. Within a spreadsheet cell, the script
> would be called using the format *=specificDaysLeft(Today(), "Monday")*.
>
> Currently, the script seems to return a value of 4, regardless of which
> day of the week I enter into it. I've been staring at this code long
> enough to go cross-eyed and I'm sure it's something really simple causing
> this problem, but I'm burnt out trying to find it. Can anyone give it a
> look and let me know if they spot the problem?
>
> Thanks!
>
> *Nic Phillips*
> *Educational Technology Specialist*
> *Oxbow High School*
> *P: 802.222.5214 <(802)%20222-5214> - ext.147*
>
> *CONFIDENTIALITY NOTE:* The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
> -----------------------------------------------------------------------
>
> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT Archive
>
> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
> Subscription to SCHOOL-IT
>
>
>
>
> --
> Brian Brumley
> Technology Integration Specialist
> [log in to unmask]
> Charlotte Central School
> 408 Hinesburg Road,  VT 05445
> http://www.ccsvt.us/
> Cell (843)343-6248 <(843)%20343-6248>
>
>
> -----------------------------------------------------------------------
>
> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT Archive
>
> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
> Subscription to SCHOOL-IT
>