How to use
- Choose Count business days or Add or subtract business days.
- Enter the dates, or a start date and a number of business days.
- Pick your weekend, then a country to skip its public holidays. Add any other dates of your own.
- Read the result and the days that were skipped.
Formula: how business days are counted
business days = calendar days − weekend days − holidays on working days
- Counting: both the start and end dates count by default, the same as Excel’s NETWORKDAYS. You can count only one of them, or neither.
- Adding: the start date is day 0, as in Excel’s WORKDAY. Day 1 is the next working day.
- Holidays are skipped only if they fall on a working day, so none is removed twice.
Examples
These match Microsoft’s own examples for Excel:
- 1 October 2012 to 1 March 2013: 110 business days. Skipping 22 November 2012, 4 December 2012 and 21 January 2013 leaves 107.
- 151 business days after 1 October 2008: 30 April 2009, or 5 May 2009 with those three holidays.
- 1 business day after a Friday is the following Monday. 5 business days after Friday 23 October 2026 is Friday 30 October.
Country holidays
Choose a country and its national public holidays for this year and the next two are skipped. The list loads from this site only when you pick a country.
- Regional holidays vary. US states, Canadian provinces, Australian states and Indian states add their own, so add those dates yourself.
- Lunar holidays can move. Eid and other Islamic holidays are calculated ahead and can shift by a day after the moon is sighted.
- Governments add one-off holidays. Scotland’s bank holiday on 15 June 2026 isn’t in the list, for example.
- Working on a holiday? Type it with a minus sign, such as -2026-12-26, to count it as a working day.
Business days in 2026
No holidays removed.
| Month | Sat–Sun weekend | Fri–Sat weekend |
|---|---|---|
| January | 22 | 21 |
| February | 20 | 20 |
| March | 22 | 23 |
| April | 22 | 22 |
| May | 21 | 21 |
| June | 22 | 22 |
| July | 23 | 22 |
| August | 21 | 22 |
| September | 22 | 22 |
| October | 22 | 21 |
| November | 21 | 22 |
| December | 23 | 23 |
| Year | 261 | 261 |
Choosing the start and end options
- Count both: the usual choice for “working days in this period”.
- Count the end date only: working days after the start date, up to the end. Use it for “how many working days until”.
- Count neither: only the days strictly between the two dates.
A contract may define “business day” or “within 5 business days” in its own way, so check the wording. Holidays are skipped only for the country you choose and the dates you type.
Holiday data comes from the open-source date-holidays project, which compiles Wikipedia’s lists (CC BY-SA 3.0). We checked the US list against OPM’s federal holidays and the UK lists against GOV.UK for 2026 and 2027.
To add calendar days instead, use the date calculator. To count every day, use the days between dates calculator.