{"id":326,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/networkdays-intl\/"},"modified":"2021-02-13T11:35:32","modified_gmt":"2021-02-13T11:35:32","slug":"networkdays-intl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/networkdays-intl\/","title":{"rendered":"NETWORKDAYS.INTL"},"content":{"rendered":"

In this article, we will delve into the NETWORKDAYS.INTL function, a versatile tool in Microsoft Excel and Google Sheets designed to compute the number of working days between two specific dates. This function is particularly useful as it allows for the exclusion of weekends (which can be customized) and any designated holidays. We will provide a detailed overview of how to effectively apply this function in various scenarios.<\/p>\n

Basic Syntax<\/h2>\n

The basic syntax for the NETWORKDAYS.INTL function is as follows:<\/p>\n

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])<\/code><\/pre>\n
    \n
  • start_date:<\/strong> The beginning date of the specified period.<\/li>\n
  • end_date:<\/strong> The ending date of the specified period.<\/li>\n
  • weekend:<\/strong> A code that identifies which days should be recognized as the weekend.<\/li>\n
  • holidays:<\/strong> An optional range listing specific dates that should be omitted from the working day count.<\/li>\n<\/ul>\n
    Calculating Workdays<\/h2>\n
    First, let\u2019s consider a basic example that utilizes the NETWORKDAYS.INTL function to determine the number of working days between two dates.<\/p>\n\n\n\n
    Start Date<\/th>\nEnd Date<\/th>\nResult<\/th>\n<\/tr>\n
    2022-10-01<\/td>\n2022-10-10<\/td>\n=NETWORKDAYS.INTL(A2, B2)<\/td>\n<\/tr>\n<\/table>\n
    In this example, the formula calculates the working days from October 1, 2022, to October 10, 2022, by default excluding the weekend days, Saturday and Sunday.<\/p>\n
    Specifying Custom Weekend Days<\/h2>\n
    The function also allows for customization of which days are treated as weekends. For instance, if you need Fridays and Saturdays to be considered as weekends, you can modify the weekend parameter:<\/p>\n\n\n\n
    Start Date<\/th>\nEnd Date<\/th>\nCustom Weekends<\/th>\nResult<\/th>\n<\/tr>\n
    2022-11-01<\/td>\n2022-11-10<\/td>\n15<\/td>\n=NETWORKDAYS.INTL(A6, B6, C6)<\/td>\n<\/tr>\n<\/table>\n
    Here, the formula computes the working days between November 1, 2022, and November 10, 2022, with Fridays and Saturdays defined as weekend days.<\/p>\n
    Excluding Holidays<\/h2>\n
    Additionally, the function can exclude holidays from the working day count. You can specify the dates you wish to exclude by using the holidays parameter:<\/p>\n\n\n\n
    Start Date<\/th>\nEnd Date<\/th>\nHolidays<\/th>\nResult<\/th>\n<\/tr>\n
    2022-12-01<\/td>\n2022-12-10<\/td>\n2022-12-05, 2022-12-08<\/td>\n=NETWORKDAYS.INTL(A10, B10, 1, D10:D11)<\/td>\n<\/tr>\n<\/table>\n
    In this scenario, the formula calculates the working days between December 1, 2022, and December 10, 2022, explicitly excluding December 5 and December 8, 2022, as holidays.<\/p>\n
    With the customization options provided by the NETWORKDAYS.INTL function for weekends and holidays, you can accurately calculate the number of working days for a given period to suit your specific needs in both Excel and Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[209],"tags":[],"class_list":["post-326","post","type-post","status-publish","format-standard","hentry","category-date-and-time"],"acf":[],"yoast_head":"\nExcel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel NETWORKDAYS.INTL function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel NETWORKDAYS.INTL function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:35:32+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/\",\"name\":\"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:35:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel NETWORKDAYS.INTL function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/networkdays-intl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Date and time\",\"item\":\"https:\/\/functiontranslator.com\/en\/date-and-time\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NETWORKDAYS.INTL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel NETWORKDAYS.INTL function does. Clear syntax explanation and useful formula examples.","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:\/\/functiontranslator.com\/en\/networkdays-intl\/","og_locale":"en_US","og_type":"article","og_title":"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel NETWORKDAYS.INTL function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/networkdays-intl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:35:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/networkdays-intl\/","url":"https:\/\/functiontranslator.com\/en\/networkdays-intl\/","name":"Excel NETWORKDAYS.INTL Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:35:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel NETWORKDAYS.INTL function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/networkdays-intl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/networkdays-intl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/networkdays-intl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Date and time","item":"https:\/\/functiontranslator.com\/en\/date-and-time\/"},{"@type":"ListItem","position":3,"name":"NETWORKDAYS.INTL"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=326"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/326\/revisions"}],"predecessor-version":[{"id":3217,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/326\/revisions\/3217"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}