In this article
- Check your answer
- Calculate NETWORKDAYS in Excel: working days between two dates
- WORKDAY: a date a number of working days away
- Different weekends: the .INTL versions
- Common questions and pitfalls
- Practical examples
- Keeping a holiday list that updates itself
- Counting a particular weekday
- Example: a Friday–Saturday weekend
- Working days left in the month, quarter or year
- Business days in other tools
- Frequently asked questions
- Sources
To count working days between two dates in Excel or Google Sheets, use =NETWORKDAYS(start, end, holidays). To find the date a number of working days after a start date, use =WORKDAY(start, days, holidays). Both skip Saturdays and Sundays automatically and any dates you list as holidays. For other weekend patterns, use NETWORKDAYS.INTL and WORKDAY.INTL.
Check your answer
The calculator below uses the same rules as NETWORKDAYS (both dates counted) and WORKDAY (start date is day 0), so you can test a formula before rolling it out.
Calculate NETWORKDAYS in Excel: working days between two dates
=NETWORKDAYS(A2, B2)
With a start date in A2 and an end date in B2, NETWORKDAYS Excel returns the number of Mondays to Fridays from A2 to B2, counting both dates. From Monday 19 October 2026 to Friday 23 October 2026, the result is 5.

To skip public holidays, list them in a range (say E2:E12) and add it as the third argument:
=NETWORKDAYS(A2, B2, $E$2:$E$12)
Holidays that fall on a weekend are ignored, so you can paste a full official list without editing it. Use dollar signs so the range stays fixed when you copy the formula down.
WORKDAY: a date a number of working days away
=WORKDAY(A2, 10, $E$2:$E$12)
This returns a date 10 working days after A2. The start date isn’t counted; one working day after Friday is Monday. Use a negative number to go back. For example, =WORKDAY(A2,-5) is five WORKDAYs before a deadline. Format the result cell as a date. Otherwise, Excel shows a serial number, like 46317, for the NETWORKDAYS Excel function.

Different weekends: the .INTL versions
Not everyone works Monday to Friday. NETWORKDAYS.INTL and WORKDAY.INTL take a weekend argument:

| Weekend | Code | Example formula |
|---|---|---|
| Saturday–Sunday | 1 | =NETWORKDAYS.INTL(A2,B2,1) |
| Friday–Saturday | 7 | =NETWORKDAYS.INTL(A2,B2,7) |
| Sunday only | 11 | =NETWORKDAYS.INTL(A2,B2,11) |
| Friday only | 16 | =NETWORKDAYS.INTL(A2,B2,16) |
| Custom pattern | “0000011” | 7 characters, Monday first; 1 = day off |
The text pattern is the most flexible: "0000110" means Friday and Saturday off, and "0000001" a six-day week with only Sunday off.
Common questions and pitfalls
Why is my count one day more than expected?
NETWORKDAYS includes both the start and the end date. If your rule excludes the start date (“10 working days from receipt”), subtract 1, or use WORKDAY to find the end date instead.

Why do I get #VALUE!?
One of the dates is text rather than a real date. Check with =ISNUMBER(A2), and type dates in ISO format (2026-10-23) to avoid day/month confusion.
What about half days?
Neither function handles half days. Count them separately and subtract 0.5 for each.
Does Google Sheets work the same?
Yes. NETWORKDAYS, WORKDAY and both .INTL versions exist in Google Sheets with the same arguments and results.
Practical examples
- Days of leave taken:
=NETWORKDAYS(first_day, last_day, holidays). - Invoice due in 30 working days:
=WORKDAY(invoice_date, 30, holidays). - Working days left this month:
=NETWORKDAYS(TODAY(), EOMONTH(TODAY(),0), holidays). - Working days in a year:
=NETWORKDAYS(DATE(2027,1,1), DATE(2027,12,31), holidays)— 261 before holidays.
For context on yearly totals, see how many working days are in a year.
Keeping a holiday list that updates itself
Put your holidays on a separate sheet in one column, select it and give it a name — Formulas → Define Name → Holidays. Your formulas then read =NETWORKDAYS(A2,B2,Holidays). When next year’s holidays are added at the bottom, update the named range (or format the list as an Excel Table so the name grows automatically). Every formula in the workbook picks up the change.

Include substitute days: When Christmas Day falls on a Saturday, the UK bank holiday moves to the following Monday or Tuesday. US federal holidays on a Saturday are observed on the Friday before. This is important for NETWORKDAYS calculations in Excel.
Counting a particular weekday
NETWORKDAYS.INTL can count single weekday occurrences. For example, count Mondays between dates for class planning. Mark every day except Monday as a “weekend” using the pattern "0111111" in networkdays excel.
=NETWORKDAYS.INTL(A2,B2,"0111111")
Change the position of the 0 for other weekdays: "1111011" counts Fridays.
Example: a Friday–Saturday weekend
In countries where the weekend is Friday and Saturday, a 20-working-day deadline from Sunday 1 November 2026 is:
=WORKDAY.INTL(DATE(2026,11,1),20,7,Holidays)
Weekend code 7 skips Fridays and Saturdays, so the count runs Sunday to Thursday.
Working days left in the month, quarter or year
| You want | Formula |
|---|---|
| Working days left this month (including today) | =NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0),Holidays) |
| Working days left this year | =NETWORKDAYS(TODAY(),DATE(YEAR(TODAY()),12,31),Holidays) |
| Working days in next month | =NETWORKDAYS(EOMONTH(TODAY(),0)+1,EOMONTH(TODAY(),1),Holidays) |
| Is a date a working day? | =NETWORKDAYS(A2,A2,Holidays)=1 |
Business days in other tools
- Python (NumPy):
numpy.busday_count('2026-10-19','2026-10-26')returns 5 — note the end date is excluded, unlike NETWORKDAYS. - SQL: most databases need a calendar table with a working-day flag; join to it and count.
- No code: the business days calculator on this site, with your own holiday list.
Frequently asked questions
What does NETWORKDAYS do?
It counts the weekdays between two dates, including both dates, minus any holidays you list.
What is the difference between NETWORKDAYS and WORKDAY?
NETWORKDAYS returns a number of days; WORKDAY returns a date a number of working days away.
How do I exclude holidays?
Put the holiday dates in a range and pass it as the last argument.
Can I use a Friday–Saturday weekend?
Yes, with NETWORKDAYS.INTL or WORKDAY.INTL and weekend code 7.




