Rules
Fifteen worked examples of business day counting across stacked closure layers
Fifteen worked examples over one invented three-layer closure arrangement in March 2027, counting and stepping business days with the arithmetic shown.
Desk
Market Desk
Who supplies what, at what price, and how that has moved.
Industry
Spreadsheet and API Tools: Google Sheets Date Settings
Spreadsheet and API tools in Google Sheets can reinterpret dates through file time zone and locale settings, serial values, and API response formatting.
Rules
Spreadsheet and API tools formula testing for parity
Spreadsheet and API tools formula parity: Excel NETWORKDAYS against Nager.Date, four pinned conventions, sixteen boundary cases, and the 1900/1904 epoch trap.
Guides
Testing an SLA deadline clock: the checks worth running before you trust it
What an SLA deadline clock has to model before any calculator is fit for it: windows, zones, pause rules, clock changes, and four acceptance tests to run.
Industry
5 things worth knowing about state calendars holidays
State calendars in 2027: how a sub-national closure is enacted and published, why it can bind one class of body and not another, and why no date appears here.
Maintenance
State calendar mistakes that quietly move a real deadline without notice
Nine state calendars mistakes that quietly produce a wrong deadline, from treating the national list as complete to trusting a tool's built-in data.
Reviews
Country calendars in Google Sheets: taming the weekend argument first
Country calendars in Google Sheets: the weekend argument that most sheets never set, one closure range per country, and the parsing trap in imported dates.
Costs
The open-day formula with rest-day sets: five weekend conventions and cross-border spans
The open-day formula takes the rest-day set as an argument, with 2027 spans under five weekend conventions and the cross-border case for two ends.
Industry
Bank of Canada payment system dates: Lynx windows and holidays
Bank of Canada payment system dates: Lynx settlement windows in Eastern time, federal holiday closures, how ACSS settles through Lynx, and your bank's cutoff.
Industry
US and Canada holiday calendars compared for cross-border contract dates
US Canada contract business days turn on two holiday calendars. Compare federal and provincial dates to stop SLA and payment terms slippage each year.
Reviews
Working days per year holidays with verified dates and sources
Working days per year in 2027 come down to the named public holidays landing on weekdays, their exact dates, and the official sources verifying each one.
Costs
Working Days Per Year Examples: Fiscal Baseline Checks
Working days per year examples: build a fiscal-span weekday baseline from monthly counts, subtract the federal holiday list for three spans, and reverse-check a reported total.
Maintenance
A working brief on add business days formula as of 2027
What the WORKDAY formula really does at the edges: rest-day starts, zero and negative counts, silently ignored text closures, and a hand method that matches.
Reviews
Days between dates by country: the directory, with corrections
Counting days between dates across a border turns on the working week, whose closure list applies, the governing zone, and which endpoints count.
Maintenance
Days between dates: the method a calculator runs and the divide by seven check
The method a days between dates calculator runs, written for paper: day of year subtraction, leap years, a divide by seven check, and when to trust a tool.
Costs
Days between dates in Excel: subtraction, times, DATEDIF and NETWORKDAYS
Excel formulas for days between dates: subtraction and inclusive counts, times in cells, DATEDIF units, NETWORKDAYS and WORKDAY, and what the sheet cannot decide.
Rules
Subtract Business Days Holidays 2027: U.S. Example
Subtract business days holidays 2027 with a U.S. example: how OPM’s observed July 5 closure shifts a backward count and which calendar should govern.
Guides
Working days per month formula: test vectors and checks for your code
Test a working days per month formula before you trust it: edge spans, a month-by-month 2027 sum, a day-by-day sweep and the off-by-one bugs.