Business Days Calculator: Formula & Worked Example

Count weekdays between two dates, excluding Saturdays and Sundays. Calculate instantly in your browser with editable inputs, a worked example and clear assumptions. No account required.

How it is calculated

Five weekdays per full week, plus weekdays in the remaining days

Includes both start and end dates. Saturdays and Sundays are excluded; public holidays are not. A reversed range returns zero.

Worked example

Start date

2026-01-01

End date

2026-01-31

Example result: 22 days

The interactive tool lets you edit every input and reset to this example. Calculations run in your browser.

Questions and answers

Are my calculator inputs sent to a server?

These calculations run in your browser. The calculator does not send your entered values to a calculation server or save them to your learning account.

Why can the result differ from a full spreadsheet model?

Each calculator uses the equation and assumptions shown on this page. Displayed values may be rounded. A workbook with different timing, fees, filters or source data can produce a different result.

Can I use the calculator without an account?

Yes. All 73 calculators are available to guest learners. The worked example shows the default inputs, and Reset restores them.

Related calculators

• Days Between Dates — Count calendar days from a start date to an end date.
• Weeks Between Dates — Calculate elapsed weeks between two dates.
• Months Between Dates — Calculate approximate elapsed months using 30.4375 days per month.

All 73 calculators · Practise in the Excel Simulator

Interactive practice runs in your browser.