Excel NETWORKDAYS Function: How to Use It, with Examples
Turkish: TAMİŞGÜNÜ

Returns the number of working days (excluding weekends) between two dates, optionally excluding holidays too.

NETWORKDAYS syntax

=NETWORKDAYS(start_date, end_date, [holidays])

In Turkish Excel: =TAMİŞGÜNÜ(başlangıç_tarihi; bitiş_tarihi; [tatiller])

ArgumentDescription
start_dateFirst date.
end_dateLast date.
[holidays]Range of holiday dates to exclude.

NETWORKDAYS examples

Sample table:

AB
1StartEnd
22026-01-052026-03-20
=NETWORKDAYS(DATE(2026,1,5),DATE(2026,1,16))
Result: 10

Working days from 5 to 16 January 2026.

Results were calculated in real Excel.

Tips for NETWORKDAYS

  • Use NETWORKDAYS.INTL if your weekend is different (e.g. Saturday is a working day).

More formula guides

More tools

About NETWORKDAYS Function

Returns the number of working days (excluding weekends) between two dates, optionally excluding holidays too.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use NETWORKDAYS Function

  1. Type the formulaStart typing =NETWORKDAYS( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is NETWORKDAYS in Turkish Excel?

In Turkish Excel, NETWORKDAYS is called TAMİŞGÜNÜ. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have NETWORKDAYS?

NETWORKDAYS is available in all current Excel versions (2010 and later, Microsoft 365).