Rules
Spreadsheet Date and Workday Counting Mistakes
Spreadsheet date and workday-count mistakes: text dates, locale-dependent imports, midnight shifts, serial values, endpoint rules, and closure ranges.
Contributor
Evelyn C. Reed
Subject: Business Days and Workday Calculators: workday, date, calculator. What needs to be clarified before choosing an approach? Background, definitions and the interpretation of available information belong to this editorial remit. Evelyn C. Reed is the editorial byline assigned to this area. Attention belongs to the constraints as well as the possibilities. This is an editorial pen name used by the publication, not a claim of an independently verified personal identity.
Guides
How dates survive or break moving between Excel, Google Sheets and APIs
Date serials, the 1900 and 1904 epochs 1,462 days apart, text dates, Google Sheets locale and time zone, and API formats, with worked values you can check in a sheet.
Industry
State Holidays and Deadlines: Who a State Closure Binds
How a US state holiday is created, whom it binds, and why a deadline count needs the federal list plus each applicable state list, with 2027 Texas dates and two worked filing examples.
Maintenance
Calendar mistakes that move a deadline, with named cases and fixes
Seven ways the wrong calendar shifts a business-day count, from the Saturday-Sunday default to copied holiday dates, each with a dated case from OPM, Alberta, Ontario or GOV.UK.
Guides
Several working weeks and holiday layers in one Excel workbook
Run WORKDAY.INTL and NETWORKDAYS.INTL across different weekends and stacked closure lists in one workbook, with a 2027 federal, state, provincial and UAE example and expected answers.
Rules
Alberta Energy Regulator filings, counting business days in Calgary and Edmonton
AER filing business days Alberta: how the regulator counts submission deadlines against Alberta statutory holidays, with worked examples for Calgary and Edmonton.
Industry
Lynx settlement windows and how federal and provincial holidays affect payments
Lynx settlement windows in Eastern time, how federal holidays and provincial desk closures delay payments, and why ACSS settlement depends on an open Lynx.
Rules
CRA business day deadlines: GST/HST and corporate dates
CRA business day deadlines for GST/HST and corporate returns: find the statutory date, check CRA holidays, and apply the weekend or holiday shift.
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.
Rules
Federal vs State Court Filing Deadlines: Counting Business Days
Federal vs state court filing deadlines: how FRCP 6 and state rules count business days, holidays and mail service differently, and where each count goes wrong.
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.
Rules
Add business days: three start conventions and fifteen worked cases excluding the start
Fifteen worked add business days cases excluding the start, plus how the three start-day conventions and a closure really move an actual deadline.
Industry
National Closure Dates by Publisher: US Federal, Federal Reserve and Canada
The 2027 national closure dates for the US federal government, the Federal Reserve and Canada, who publishes each, and how one missing closure moves a count.
Rules
How to calculate the days between two dates, step by step
A leap-year-proof day number built from the March-first year, tested on 1900 and 2000, reconciled with spreadsheet subtraction and NETWORKDAYS, and used for date-only services.
Guides
Who actually publishes the state calendars that set a deadline?
Who publishes the state calendars that actually govern a deadline, why the personnel list is the trap, and how to build one office's calendar properly.
Industry
Counting Business Days Backward From a Fixed Deadline
Count back from a fixed deadline with WORKDAY, see why the round trip does not close, and what a holiday inside the window does, using Memorial Day 2025.
Maintenance
Why a year's working day total starts with 260, 261 or 262 weekdays
Explains why a year's working day total starts with 260, 261 or 262 weekdays, how leftover days decide the count, and why closures and payroll divisors sit on top.
Industry
How to calculate working hours between two timestamps in Excel and Google Sheets
Count working hours between two timestamps by clipping each day's window to the interval. Seven worked intervals, a spreadsheet formula, and the break, time zone and clock-change edges.
Guides
How to Turn 'Within N Business Days' Into a Date
Settle the working week, closure issuer, receipt cut-off and governing place first, then apply the documented WORKDAY rules, a hand method and a test table.