Business Days accuracy and testing

Formula source

• The algorithm starts from the selected start date, moves forward one day at a time until it reaches the end date, and counts only weekdays. That means it excludes the start date itself and includes the end date if that day is Monday through Friday.

Test cases

Known limitations

• Holiday presets are source-dated planning references and may not include private, agency-specific, emergency, or local closures.

Assumptions

• Business days are defined here as Monday through Friday only.
• Source-dated holiday presets can exclude recognized weekday holidays, and manual excluded days remain editable.
• The count excludes the start date and includes the end date when the end date falls on a weekday.

Unit handling

• Start Date accepts calendar dates.
• End Date accepts calendar dates.
• Holiday Calendar accepts one of the configured options.
• Manual Excluded Days accepts numeric values.
• Business Days is displayed in days.

Rounding rules

• Number displays use up to 2 decimal places in the calculator UI.
• Input precision follows configured step values where provided.

Version history

Change log