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!

On Thu, Mar 16, 2017 at 2:01 PM, Phillips, Nic <[log in to unmask]>

> 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:
> 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 <> the SCHOOL-IT Archive
> Manage <> your
> Subscription to SCHOOL-IT

Brian Brumley
Technology Integration Specialist
[log in to unmask]
Charlotte Central School
408 Hinesburg Road,  VT 05445
Cell (843)343-6248