Skip to content

Excel function · Date & time

Excel NETWORKDAYS function

NETWORKDAYS counts the working days between two dates, leaving out Saturdays and Sundays and, if you like, the dates in a holiday list. Use it for project lengths, working days per month and delivery tracking.

In Turkish Excel: TAMİŞGÜNÜ

What it does

=NETWORKDAYS(A2,B2) counts the Monday-to-Friday days between A2 and B2; the start and end days count too if they are working days. Give a range of holiday dates as the third argument and holidays that fall on weekdays are left out as well.

Keep the holiday list in its own area, one real date per row, and lock it in the formula like $F$2:$F$9. Some holidays, such as 1 January, are on a fixed date, while others such as Easter move every year, so the list needs that year's dates. Half days are counted as full days by this function.

If the weekend is not Saturday and Sunday (for example only Sunday off), use NETWORKDAYS.INTL. To add working days to a date use WORKDAY; for a difference in calendar days use DAYS.

Syntax

English Excel=NETWORKDAYS(start_date, end_date, [holidays])
Turkish Excel=TAMİŞGÜNÜ(başlangıç; bitiş; [tatiller])

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription
start_dateRequiredThe date the count starts.
end_dateRequiredThe date the count ends. If it is before the start date, the result is negative.
holidaysOptionalA range of dates not to count as working days, e.g. $F$2:$F$9. Holidays falling on a weekend are not subtracted again.

Examples

1Calendar days and working days for each task

Column D counts calendar days including the start and end, column E only Monday to Friday. The example leaves the holiday argument out.

D2fx=C2-B2+1
Calendar days and working days for each task: example table
ABCDE
1TaskStartEndCalendar DaysWorking Days
2Analysis2-Nov-20266-Nov-202655
3Design9-Nov-202620-Nov-20261210
4Build23-Nov-202618-Dec-20262620
5Testing21-Dec-202631-Dec-2026119
  • D2 (filled down to D5)=C2-B2+1
  • E2 (filled down to E5)=NETWORKDAYS(B2,C2)

The design task spans 12 calendar days, but once the weekend in between is removed, 10 working days remain. Because the start and end days count, the analysis task is 5 working days.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

2Working days per month with public holidays removed

Column B finds the last day of the month with EOMONTH. Column C removes weekends only; column D also removes the holiday list in F. The list holds the 2026 bank holidays in England.

B2fx=EOMONTH(A2,0)
Working days per month with public holidays removed: example table
ABCDEF
1Month StartMonth EndWorking Days (No Holidays)Working Days (Holidays Removed)Bank Holiday
21-Apr-202630-Apr-202622201-Jan-2026
31-May-202631-May-202621193-Apr-2026
41-Aug-202631-Aug-202621206-Apr-2026
51-Dec-202631-Dec-202623214-May-2026
625-May-2026
731-Aug-2026
825-Dec-2026
928-Dec-2026
  • B2 (filled down to B5)=EOMONTH(A2,0)
  • C2 (filled down to C5)=NETWORKDAYS(A2,B2)
  • D2 (filled down to D5)=NETWORKDAYS(A2,B2,$F$2:$F$9)

In April, Good Friday and Easter Monday fall on weekdays, so the working days drop from 22 to 20. December loses Christmas Day and the Boxing Day substitute: 21. Put your own country's dates in the list and the results follow.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

Common errors and fixes

#VALUE!

Cause: One of the dates, or a cell in the holiday list, is text that cannot be converted to a date.

Fix: Make sure the holiday list holds real dates.

One day too many

Cause: The start and end days are both counted, so the result looks one higher than expected.

Fix: That is how the function is defined; subtract 1 if you only want the days in between.

Holidays not removed

Cause: The holiday range shifted when the formula was filled down, or the holidays were typed as text.

Fix: Lock the range like $F$2:$F$9 and enter the dates as real dates.

Good to know

  • Working days in a month, with A2 the first of the month: =NETWORKDAYS(A2,EOMONTH(A2,0),$F$2:$F$9) (EOMONTH).
  • Where Saturday is a working day, =NETWORKDAYS.INTL(A2,B2,11,$F$2:$F$9) treats only Sunday as the weekend.

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Add a column to the project list that counts the working days between the start and end dates, leaving out the dates in my holiday list

Convert to table

Bring the project list and the holiday list into the tool and type this. Nexell adds the working-days column with real Excel formulas and shows it in the preview; in the downloaded file, the counts update when you add a date to the holiday list.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

How do I calculate working days between two dates in Excel?

=NETWORKDAYS(A2,B2) counts the days other than Saturday and Sunday. To leave out public holidays as well, list their dates in a range and pass it as the third argument: =NETWORKDAYS(A2,B2,$F$2:$F$9).

Does NETWORKDAYS count the start date?

Yes; if the start and end dates are working days, both are counted. Monday 2 November 2026 to Friday 6 November is 5 working days.

Related functions

All date & time functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free