I had no luck with your script. 
But this formula works in google sheets


In that formula B2 is todays date. "sun" is the day of the week I want to measure. 

Here is another example


that gives me a result of 3. 

I'd say skip the script and use the built in functions 

Good luck. 


On Thu, Mar 16, 2017 at 3:21 PM Charlie MacFadyen <[log in to unmask]> wrote:
Rather than passing today's date into the function, you can just use new Date().  JavaScript will create a new Date object based on the current time.  Documentation is here.

Pasting in a version I got to work (I think!)


function test(){
function specificDaysLeft(dayName) {
  // set day names
  var dayNames = ["Sunday", "Monday", "Tuesday", "Wednesday", 
    "Thursday", "Friday", "Saturday"

  // establish variables
  todaysDate = new Date();
  var year = todaysDate.getYear();
  var month =todaysDate.getMonth();
  var today = todaysDate.getDate();

  // change dayName string to index of array
  var day = dayNames.indexOf(dayName);

  // determine the number of days in current month
  var daysinMonth = new Date(year, month+1, 0).getDate();

  // set counter
  var sumDaysLeft=0;

  // iterate over the days and compare to day
  for(var i=today; i<=daysinMonth; i++) {
    var checkDay = new Date(year, month-1, parseInt(i)).getDay();    
    if(day == checkDay) {
      sumDaysLeft ++;

  // show amount of day names in month
  return sumDaysLeft;

Charlie MacFadyen
Technology Integration Specialist
Champlain Valley Union HS
369 CVU Rd., Hinesburg, VT, 05461

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

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]> 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:

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

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


Search the SCHOOL-IT Archive

Manage your Subscription to SCHOOL-IT


Search the SCHOOL-IT Archive

Manage your Subscription to SCHOOL-IT


Search the SCHOOL-IT Archive

Manage your Subscription to SCHOOL-IT