NETWORKDAYS vs WORKDAY in Excel: How Each One Counts, With Tested Examples
Excel has two pairs of business-day functions, and they answer different questions. NETWORKDAYS counts how many working days lie between two dates. WORKDAY starts at a date and returns the date a given number of working days later (or earlier). Their .INTL versions do the same thing with a weekend you choose. Most spreadsheet bugs with these functions come from one detail: NETWORKDAYS counts both the start and the end date, while WORKDAY never counts the start date. This guide walks through that and the other edge cases, with examples you can paste into a sheet.
The four functions at a glance
| Function | Answers | Start date counted? | Weekend |
|---|---|---|---|
NETWORKDAYS(start, end, [holidays]) | How many working days from start to end? | Yes, and the end date too | Saturday and Sunday |
NETWORKDAYS.INTL(start, end, [weekend], [holidays]) | Same, with a custom weekend | Yes, and the end date too | Code or 7-character string |
WORKDAY(start, days, [holidays]) | Which date is N working days away? | No | Saturday and Sunday |
WORKDAY.INTL(start, days, [weekend], [holidays]) | Same, with a custom weekend | No | Code or 7-character string |
Microsoft’s documentation describes NETWORKDAYS as returning “the number of whole working days between start_date and end_date”, and WORKDAY as returning the date “the indicated number of working days before or after” the start date. In practice “between” includes both endpoints, which the examples below show.
Tested examples
Every result in this table was calculated in a spreadsheet (LibreOffice Calc, which implements the same functions) and cross-checked against an independent Python calculation. All dates are in January or July 2027. Excel shows WORKDAY results as serial numbers until you format the cell as a date.
| Formula | Situation | Result | Why |
|---|---|---|---|
=NETWORKDAYS(DATE(2027,1,4),DATE(2027,1,8)) | Monday to Friday of the same week | 5 | Both ends are counted: Mon, Tue, Wed, Thu, Fri. |
=WORKDAY(DATE(2027,1,4),5) | 5 working days after Monday 4 Jan | 2027-01-11 (Mon) | The start date is not counted, so day 1 is Tuesday. |
=NETWORKDAYS(DATE(2027,1,4),DATE(2027,1,4)) | Same start and end date | 1 | A single working day counts as 1, not 0. |
=NETWORKDAYS(DATE(2027,1,8),DATE(2027,1,4)) | End date before start date | -5 | Reversed dates give a negative count of the same size. |
=WORKDAY(DATE(2027,1,2),1) | 1 working day after Saturday 2 Jan | 2027-01-04 (Mon) | A weekend start date is simply stepped over. |
=WORKDAY(DATE(2027,1,2),0) | 0 working days after Saturday 2 Jan | 2027-01-02 (Sat) | Zero days returns the start date, even on a weekend. |
=WORKDAY(DATE(2027,7,6),-1,DATE(2027,7,5)) | 1 working day before Tuesday 6 July, with 5 July as a holiday | 2027-07-02 (Fri) | Negative days count backwards and skip holidays the same way. |
=WORKDAY(DATE(2027,1,4),2.9) | Fractional days | 2027-01-06 | 2.9 is truncated to 2, not rounded to 3. |
The off-by-one trap: converting between the two
Because NETWORKDAYS includes the start date and WORKDAY skips it, they are not inverses. If the start date is a working day, =NETWORKDAYS(A2, WORKDAY(A2, 10)) returns 11, not 10. With A2 = Monday 4 January 2027, WORKDAY returns Monday 18 January, and NETWORKDAYS counts 4 January as well as the ten days after it.
Decide which convention your rule uses before writing the formula. A “respond within 10 business days” clause usually means day 1 is the day after the trigger, which matches WORKDAY. A question like “how many days did this person work in January?” wants both ends included, which matches NETWORKDAYS. If you need an exclusive count between two dates, subtract 1 when the start date is itself a working day, for example =NETWORKDAYS(A2,B2)-(NETWORKDAYS(A2,A2)=1).
Holidays: what the list does and does not do
The holidays argument removes dates from the working calendar. A holiday that already falls on a weekend has no extra effect, so it is never subtracted twice. For example, =NETWORKDAYS(DATE(2027,12,20),DATE(2027,12,31),H2:H4) with 24, 25 and 31 December 2027 in H2:H4 returns 8: ten weekdays minus the two holidays that fall on weekdays. Saturday 25 December changes nothing.
The list must hold the observed dates. For the US federal calendar in 2027 that means 24 December for Christmas and 31 December for New Year’s Day 2028, not 25 December and 1 January. With all twelve observed 2027 federal holidays in the list, =NETWORKDAYS(DATE(2027,1,1),DATE(2027,12,31),H2:H13) returns 249. The full month-by-month breakdown is in Business days in 2027.
Microsoft recommends entering dates with the DATE function or as results of other formulas, because dates typed as text can cause problems. Keep holidays in a range of real date cells rather than a text list.
A holiday also matters when it is the start date of a backward count. =WORKDAY(DATE(2027,12,31),-10,H2:H4) with 25 November, 24 December and 31 December listed returns 2027-12-16: the start date is not counted whether or not it is a holiday, so day 1 is Thursday 30 December.
Custom weekends with NETWORKDAYS.INTL and WORKDAY.INTL
The weekend argument accepts a number or a seven-character string. Numbers 1 to 7 are two-day weekends (1 is Saturday–Sunday, 2 is Sunday–Monday, and so on to 7, Friday–Saturday). Numbers 11 to 17 are single-day weekends (11 is Sunday only, 17 is Saturday only). In the string form each character is a day starting from Monday, with 1 meaning a day off, so "0000011" is Saturday and Sunday. Here is February 2027 counted with different weekends:
| weekend argument | Days off | =NETWORKDAYS.INTL(DATE(2027,2,1),DATE(2027,2,28),weekend) |
|---|---|---|
1 or omitted | Saturday, Sunday | 20 |
7 | Friday, Saturday | 20 |
11 | Sunday only | 24 |
"0000011" | Saturday, Sunday (string form) | 20 |
"1111111" | Every day | 0 (always 0) |
February 2027 has exactly four of each weekday, so any two-day weekend leaves 20 working days and a one-day weekend leaves 24. In other months the codes give different results. With a Friday–Saturday weekend, =WORKDAY.INTL(DATE(2027,1,3),10,7) returns 2027-01-17, a Sunday, because Sunday is a working day under code 7. According to Microsoft, a weekend string of the wrong length or with characters other than 0 and 1 returns #VALUE!. Microsoft’s WORKDAY.INTL example also shows that a weekend argument of 0 returns #NUM!.
If you are setting up a calendar for a Friday–Saturday or Saturday–Sunday country, the weekend days guide covers which days to use.
Errors you may see
- #VALUE!: an argument is not a valid date, or the weekend string is invalid.
- #NUM!: for WORKDAY and WORKDAY.INTL, the start date plus the offset lands outside Excel’s date range, or the weekend argument is not a valid code (Microsoft’s example uses 0).
- A five-digit number instead of a date: WORKDAY returned a date serial number; apply a date format to the cell.
Checking a result outside Excel
When a count is disputed, it helps to see the actual days counted. WorkdayMap uses the WORKDAY convention by default (the base date is not counted unless you turn that option on) and shows the reason for each skipped date. Here is example G from the table: 1 working day before 6 July 2027 with 5 July closed ↗.