Business Days Calculator
Business Days is evaluated from Start Date and End Date. The calculation reports Business Days, Total Calendar Days and Weekend Days.
Results
About the Business Days Calculator
The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
For each day, check if getDay() is 1 - 5 (Mon - Fri).
Weekend days = Total calendar days - Business days.
Complete weeks = floor(total calendar days / 7).
Note: Federal holidays are NOT excluded - add manually as needed.
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: For each day, check if getDay() is 1 - 5 (Mon - Fri). Weekend days = Total calendar days - Business days. Complete weeks = floor(total calendar days / 7). Note: Federal holidays are NOT excluded - add manually as needed. Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: Q1 2025: Jan 1 – Mar 31
Inputs
With Start Date = 2025-01-01 and End Date = 2025-03-31 as the stated inputs, the result is Business Days = 63 days, Total Calendar Days = 89 days and Weekend Days = 26 days. Each value corresponds to the declared output fields.
Example 2: SEC 8-K Filing Window: Announce on Mar 3, 2025 + 4 business days
Inputs
With Start Date = 2025-03-03 and End Date = 2025-03-07 as the stated inputs, the result is Business Days = 4 days, Total Calendar Days = 4 days and Weekend Days = 0 days. Each value corresponds to the declared output fields.
Example 3: Mortgage Closing Disclosure: Required 3 BD before closing
Inputs
With Start Date = 2025-04-14 and End Date = 2025-04-17 as the stated inputs, the result is Business Days = 3 days, Total Calendar Days = 3 days and Weekend Days = 0 days. Each value corresponds to the declared output fields.
Example 4: Full year business days: Jan 2 – Dec 31, 2025
Inputs
With Start Date = 2025-01-02 and End Date = 2025-12-31 as the stated inputs, the result is Business Days = 259 days, Total Calendar Days = 363 days and Weekend Days = 104 days. Each value corresponds to the declared output fields.
Common Use Cases
- Calculate payment due date in business days for contracts
- Determine SEC filing deadlines (measured in business days)
- Count working days for payroll and HR planning