Features
Building state calendars in Excel with one column per layer
State calendars in Excel: one column per layer, a union built with a formula rather than by hand, and the lookup that picks the right layers for a row.
Section
Features
Features
Working hours Google Sheets: setup and timezone trap
Set up working hours Google Sheets formulas with Open and Close ranges, holiday dates, elapsed-time formatting, and the spreadsheet and Apps Script time zones.
Features
Monday to Friday totals for any year: why the count is only 260, 261 or 262
How to count Monday to Friday weekdays in a year: 52 weeks give 260, leftover days add one or two, and the total is 260, 261 or 262. The table covers all start days.
Features
What matters most in working days per month holidays
Working days per month in 2027: how a monthly closure list is sourced, versioned and applied, and why this page states no holiday date for any country.
Features
How SLA deadline calculators determine due dates
SLA deadline calculators turn contract rules into due moments; see how business-hour calendars, pauses, time zones, and boundary rules change the result.