Q:

Script to open "Today" in multi-sheet Google Sheet

Sample Sheet- So, I am new to this part. Our work schedule is in by-weekly format, each two-week pay-period is on a separate sheet. 
I need a script to cause it to open to the current date whenever a user accesses the sheet from their Google Drive.
Similar to this, but something isn't right:
function onOpen() {
  var today = new Date();
  var ss = SpreadsheetApp.getActive();
  ss.setActiveSheet(ss.getSheets()[today.getMonth()]);
}

A:

This script should bring you to the sheet with the current date..
function onOpen() {
var today = format(new Date());
var ss = SpreadsheetApp.getActive();
var sheets = ss.getSheets()
    .forEach(function (s) {
        var val = s.getRange("C2:P2")
            .getValues()[0];
        for (var i = 0, len = val.length; i < len; i++) {
            if (format(val[i]) === today) {
                ss.setActiveSheet(s)
                break;
            }
        }
    });
}

function format(date) {
return formattedDate = date.getMonth() + 1 + "/" + date.getDate()
}

See if this works ?

