Excel business days with holidays
Count working dates between two dates, including both endpoints. Add your own holidays and choose which weekdays are nonworking.
Set your calendar
Use exact ISO dates from 1901-01-01 to 9999-12-31. Maximum span: 36,600 calendar days, including endpoints. Times and timezone offsets are not accepted.
Excel weekend mask: 0000011. Monday first; 1 = nonworking, 0 = working.
Up to 500 nonblank holiday entries and 20,000 UTF-8 bytes. Blank lines are ignored. Duplicate dates count once. A holiday on a nonworking weekday is not subtracted again. Dates outside the range do not reduce it. No national holiday calendar is supplied.
Business days
Excel formula for these inputs
Put the listed holidays into H2:H501 as real Excel dates, leaving unused cells blank. The formula references that range only when you supplied holidays. It uses English function names and comma separators.
Worked example: one week, one working-day holiday
September 21–27, 2026 contains seven calendar dates. With Saturday and Sunday excluded there are five eligible weekdays. September 23 removes one. September 26 is already a Saturday, so listing it as a holiday removes nothing further. Listing September 23 twice still removes it only once. The result is 4 business days. Reverse the dates and the result is −4.
Use the example workbook
On Calculator, edit B6 (start), B7 (end), B8 (seven-character weekend mask) and E6:E25 (holiday dates, 20 slots). B4 returns the signed count. Blank start/end/mask cells produce “Enter dates and mask”; invalid Excel values remain visible as errors. Store the mask as text so leading zeroes remain. The shipped sample returns 4.
=NETWORKDAYS.INTL(B6,B7,B8,E6:E25)The Examples sheet contains independent expected results beside live formulas: an ordinary week (5), a working-day holiday (4), a weekend holiday (5), duplicate holidays (4), a reversed range (−4), a same-day weekday (1), a same-day holiday or weekend (0), all-working days (7), all-nonworking days (0), and a Friday/Saturday weekend (5). Change an input and compare the calculated result. Expected cells describe the original sample, so they do not update.
Dates, direction and masks
Both endpoints count if they are working days. An end date before the start returns a negative count; a range with no working dates returns zero in either direction. The mask has seven binary characters, Monday to Sunday. 0000011 excludes Saturday/Sunday, 0000110 excludes Friday/Saturday, 0000000 excludes no weekdays, and 1111111 excludes every weekday.
Excel versions and locale
Microsoft documents NETWORKDAYS.INTL for Microsoft 365 on Windows/Mac, Excel 2016–2024 where listed, and Excel Web App. The calculator uses date-only arithmetic without local timezones. Excel uses numeric date serials; enter dates using DATE(year,month,day) if your locale might misread a typed date. The download displays dates as YYYY-MM-DD. Formula text uses English names and commas; localized Excel may require different names or semicolons.
The existing date-difference calculator has a simple Monday–Friday count without holiday input. Use this page when holidays or custom weekends matter. Browse tutorials and Excel tips.