Google App Scripts - Holiday Date Checker

This script help to check whether your supplied date is holiday or not. The script rely on Google Public Holiday Calendar to determine whether the date is holiday or not.

You can open Script Editor under Tools Menu

Once you in Script editor page, you can paste the following code in the editor. Alternatively, you can also go to this link to get the latest code.

function myFunction() { var checkDate = new Date('2021-01-01'); if( holiday(checkDate) == 1){ Logger.log(checkDate + " is holiday"); } else{ Logger.log(checkDate + " is not holiday"); } } function holiday(dateToCheck) { // This function can help check whether the date you enter is public holiday // This is based on Google holiday calander, however, Google does not follow Minstry of Manpower (MOM) published public holiday, // therefore an exclusion list is created to filter out those holiday not listed in MOM list. // special holiday should not be included, example, polling day var cal = CalendarApp.getCalendarsByName("Holidays in Singapore"); // exclusion list of holidays which are not part of MOM published public holiday const nonHolidayArray = ["Christmas Eve","New Year's Eve","Children's Day","Easter Saturday","Easter Sunday"]; var holidays = cal[0].getEventsForDay(dateToCheck); var isHoliday = 0; // if there is only one holiday per day if (holidays.length >= 1){ for (var i = 0; i < holidays.length; i++){ var eventTitle = holidays[i].getTitle(); // if the title is not in the exclusion list, then is holiday if ( nonHolidayArray.indexOf(eventTitle) == -1 ){ isHoliday = 1; } } } return isHoliday; }

Before you can run this script, you need to add in the Google Public Holiday Calendar. For this example, i am using Singapore Public Holiday Calendar but you should be able to use this script for different country calendar.

Go to calendar page, under Other Calendars, select Browse calendars of interest.

Expand Regional holidays and tick  Holidays in Singapore. As you can see, Google has extensive list of holiday calendar for a lot of countries.

Once the calendar is setup, you can try out the script. If you are not familiar with Google App Scripts, running the script for the very first time will usually has permission prompt. Just follow the instruction and allow this script to access.

To test the script, you can just edit the following line to supply the date you want to test. The format is 'yyyy-mm-dd'.

var checkDate = new Date('2021-01-01');

Under Tools Menu, click Run - Run Function - myFunction

Once the script is done, under Tools menu, you can cick View - Logs to check the result.

You can see some sample log output below