Print

Print


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