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:


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?


Nic Phillips
Educational Technology Specialist
Oxbow High School
P: 802.222.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