{"id":1213,"date":"2018-07-02T17:09:09","date_gmt":"2018-07-02T17:09:09","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1213"},"modified":"2023-11-03T10:52:05","modified_gmt":"2023-11-03T10:52:05","slug":"networkdays","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/","title":{"rendered":"NETWORKDAYS function"},"content":{"rendered":"\n

NETWORKDAYS function is a useful tool in Excel for calculating the number of working days between two given dates. It excludes weekends and, optionally, specified holidays to provide a straightforward way of tracking business days.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

NETWORKDAYS(start_date, end_date, [holidays])<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
start_date<\/b><\/td>The start date for the calculation.<\/td><\/tr>
end_date<\/b><\/td>The end date for the calculation.<\/td><\/tr>
[holidays]<\/b><\/td>(Optional) A range or array of dates that you want to exclude from the working days. These can be specified as individual dates or a reference to a range of cells containing holiday dates.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

NETWORKDAYS function is quite straightforward to use. Here’s how you can use it with some examples:<\/p>\n\n\n\n

Let’s say you want to calculate the number of working days between two dates. You have the start date in cell A1, the end date in cell B1, and your holidays in the range C1:C5.<\/p>\n\n\n\n

1. In an empty cell, enter the formula:<\/p>\n\n\n\n

=NETWORKDAYS(A1, B1, C1:C5)<\/code><\/pre>\n\n\n\n
This formula will return the number of working days between the start date (A1) and the end date (B1), excluding the dates in the range C1:C5 as holidays.<\/p>\n\n\n\n
2. You can also use NETWORKDAYS without specifying holidays. In this case, the function will only exclude weekends (Saturdays and Sundays) from the calculation.<\/p>\n\n\n\n
=NETWORKDAYS(A1, B1)<\/code><\/pre>\n\n\n\n
3. To count working days within a specific date range without holidays, you can use NETWORKDAYS.INTL function:<\/p>\n\n\n\n
=NETWORKDAYS.INTL(A1, B1, 1)<\/code><\/pre>\n\n\n\n
Here, the “1” argument corresponds to a weekend of Saturday and Sunday.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
Let’s illustrate the use of NETWORKDAYS function with a few examples:<\/p>\n\n\n\n
Example 1:<\/b> Calculate working days between two dates with specified holidays.<\/p>\n\n\n\n
=NETWORKDAYS(\"2023-11-01\", \"2023-11-15\", {\"2023-11-05\",\"2023-11-11\"})<\/code><\/pre>\n\n\n\n
This formula calculates the number of working days between November 1, 2023, and November 15, 2023, excluding November 5, 2023, and November 11, 2023, as holidays.<\/p>\n\n\n\n
Example 2:<\/b> Count working days within a date range without specifying holidays.<\/p>\n\n\n\n
=NETWORKDAYS(\"2023-11-01\", \"2023-11-15\")<\/code><\/pre>\n\n\n\n
This formula calculates the working days between November 1, 2023, and November 15, 2023, without specifying any holidays. It will exclude weekends by default.<\/p>\n\n\n\n
Additional Information<\/h2>\n\n\n\n
If you need to customize the weekend days or use a different basis for counting working days, you can explore the NETWORKDAYS.INTL function, which allows more flexibility in specifying weekend days and holidays.<\/p>\n","protected":false},"excerpt":{"rendered":"
NETWORKDAYS function is a useful tool in Excel for calculating the number of working days between two given dates. It excludes weekends and,…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nNETWORKDAYS function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"NETWORKDAYS function\" \/>\n<meta property=\"og:description\" content=\"NETWORKDAYS function is a useful tool in Excel for calculating the number of working days between two given dates. It excludes weekends and,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T17:09:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T10:52:05+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"NETWORKDAYS function\",\"datePublished\":\"2018-07-02T17:09:09+00:00\",\"dateModified\":\"2023-11-03T10:52:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\"},\"wordCount\":348,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\",\"name\":\"NETWORKDAYS function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T17:09:09+00:00\",\"dateModified\":\"2023-11-03T10:52:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/networkdays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"NETWORKDAYS function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"NETWORKDAYS function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/","og_locale":"en_US","og_type":"article","og_title":"NETWORKDAYS function","og_description":"NETWORKDAYS function is a useful tool in Excel for calculating the number of working days between two given dates. It excludes weekends and,...","og_url":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/","article_published_time":"2018-07-02T17:09:09+00:00","article_modified_time":"2023-11-03T10:52:05+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"NETWORKDAYS function","datePublished":"2018-07-02T17:09:09+00:00","dateModified":"2023-11-03T10:52:05+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/"},"wordCount":348,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/","url":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/","name":"NETWORKDAYS function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T17:09:09+00:00","dateModified":"2023-11-03T10:52:05+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/networkdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/networkdays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"NETWORKDAYS function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1213"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1213"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1213\/revisions"}],"predecessor-version":[{"id":16523,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1213\/revisions\/16523"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}