A place to expand your knowledge of Google Workspace, learn new Google Sheets formulas and tricks, and automate the boring stuff with Google Apps Script.
More?! Well, I also explore front-end development (JavaScript, HTML, CSS) and dive into other Google Cloud products like Firebase, and all the fancy Google APIs like Maps, Document AI, Chat, Admin Directory and so… so much more.
You can select from the 3 main categories below and see what I have been writing lately. In the sidebar, you can select a category item or use the search bar in the top right.
Want some more structured content? Head over to my courses pages for FREE and quality courses to upskill than grey mush 🧠! Need a handy solution for Google Sheets? Check out my products page or my list of Google Workspace Add ons.
All Posts
Latest Posts
Extracting the Valid Workdays Between Two Dates in JavaScript
Given a start date, end date, weekends and, holidays we will extract the valid workdays between two dates in JavaScript in this tutorial. Sometimes we need to work backward from a date range and extract all the valid workdays within that range. Of course, we will need to exclude holidays and also days off for … Continue reading "Extracting the Valid Workdays Between Two Dates in JavaScript"...
Calculate the Workday End Date in JavaScript
Given a start date, number of days, and holidays, this script calculates the end date of a workday period using JavaScript. If you are looking to get a list of workdays in a range, then check out this tutorial: Extract Workdays From a Date Range in JavaScript...
Extracting Overlapping date ranges between 2 Date Ranges with JavaScript
I recently had a project where I had to extract the date range between two sets of overlapping date ranges in JavaScript*. Let’s say our user wanted to see any overlapping date ranges between "2024-09-01" and "2024-09-16". For the following set of date ranges: "29 August 2024" – "18 September 2024" "3 September 2024" – " 10 … Continue reading "Extracting Overlapping date ranges between 2 Date Ranges with JavaScript"...
Is a Year a Leap Year? Gregorian Calendar & JavaScript
Earth doesn’t perfectly orbit the Sun every 365 days. Rather, it irritatingly must make its orbit in oh, I don’t know, roughly 365.242190 days each year. Due to this inconsiderate behaviour, we must add a leap year into our common calendar known as the Gregorian Calendar. Like, I presume, many of us, I thought a … Continue reading "Is a Year a Leap Year? Gregorian Calendar & JavaScript"...
Get the Day of the Year in JavaScript
Sometimes it can be handy to find the day of the year* that a particular date falls on in JavaScript. Let’s say you want to get the day of the year for Pie Day (14 Mar 2024). Check out the code: *This tutorial is for the Gregorian Calendar...
Courses
A growing list of free and paid course: