Compare NETWORKDAYS and NETWORKDAYS.INTL in Google Sheets with a ten-project practice file, weekend codes, holiday handling and worked examples you can check by hand.
Google Sheets
Dynamic Calendar in Google Sheets: 6 Easy Steps (Free Template)
Build a dynamic calendar in Google Sheets that redraws itself when you pick a year and month, using DATEVALUE, one SEQUENCE formula, a DD number format and a conditional formatting rule.
Tables in Google Sheets: How to Create, Format and Use Them
A step-by-step guide to Tables in Google Sheets: insert ready-made tables, set column types, convert a range, change colours, save group-by and filter views, rename tables and use table references like =SUM(Sales_Data[Sales]) in formulas.
Pivot Table Guide for Google Sheets (3 Step-by-Step Examples)
A practical pivot table guide for Google Sheets: build three real summaries from a sales dataset (totals by product, country and product metrics, and percent of sales by segment), plus calculated fields, date grouping and fixes for common problems.
Sales Commission Template with Bonus Amount in Google Sheets
A Google Sheets sales commission template that applies tiered commission rates and target-based bonuses to every sale and totals commission, bonus and earnings for any date range. See each tab, a worked example and the formulas behind it.
Filter and Filter View in Google Sheets: Step-by-Step Guide
Learn how to use Filter and Filter View in Google Sheets: filter by values, condition, colour and custom formula, then save a personal filter view that does not change the sheet for collaborators.
Dynamic Monthly Attendance Template in Google Sheets with Check Boxes (Free Download)
A free monthly attendance template in Google Sheets with check boxes that builds the calendar from one month cell, skips weekends and calculates present days, absent days and absenteeism automatically.
Project Plan or Gantt Chart in Google Sheets
A practical guide to the Project Plan (Gantt Chart) template in Google Sheets: enter tasks, start dates and durations, and the sheet calculates end dates and draws red, amber and green bars by status. Includes the formulas to rebuild it yourself.
Weekly Roster Template in Google Sheets (Free)
A free weekly roster template in Google Sheets with shift drop-downs, automatic week-off and leave counts, a red-row check for two week offs and a daily Shift Wise Count. See how it works and how to set it up for your team.
Project Management Issue Tracker in Google Sheets
A ready-to-use Project Management Issue Tracker in Google Sheets with an input table, Priority, Status and Assigned To slicers, and a Summary tab showing Resolved%, overdue issues and critical open issues. See every field and how to set it up.