{"id":489,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/workday-intl\/"},"modified":"2021-02-13T11:37:01","modified_gmt":"2021-02-13T11:37:01","slug":"workday-intl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/workday-intl\/","title":{"rendered":"WORKDAY.INTL"},"content":{"rendered":"

Today, we’re going to explore how to use the WORKDAY.INTL<\/strong> function in Microsoft Excel and Google Sheets. This function is designed to calculate a future or past date from a specified starting date, accounting for working days only and optionally excluding weekends and listed holidays.<\/p>\n

Understanding the Syntax<\/h2>\n

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

WORKDAY.INTL(start_date, days, [weekend], [holidays])<\/code><\/pre>\n
    \n
  • start_date:<\/strong> The date from which the calculation will begin.<\/li>\n
  • days:<\/strong> The number of working days to add (if positive) or subtract (if negative) from the start_date.<\/li>\n
  • weekend:<\/strong> This optional parameter allows you to define which days of the week should be treated as weekends. By default, this is set to 1, which treats Saturday and Sunday as non-working days. You can modify this according to your region’s workweek by using different numerical codes.<\/li>\n
  • holidays:<\/strong> Another optional argument, this is a range of cells that contain dates which should be recognized as non-working holidays.<\/li>\n<\/ul>\n
    Examples of Usage<\/h2>\n
    To better understand the practical applications of the WORKDAY.INTL<\/strong> function, let’s go through some examples:<\/p>\n\n\n\n\n\n\n
    Formula<\/th>\nDescription<\/th>\nResult<\/th>\n<\/tr>\n
    =WORKDAY.INTL(\"6\/1\/2022\", 10)<\/code><\/td>\nAdd 10 working days to June 1, 2022, with the default weekend setting.<\/td>\nJune 15, 2022<\/td>\n<\/tr>\n
    =WORKDAY.INTL(\"6\/1\/2022\", -5)<\/code><\/td>\nSubtract 5 working days from June 1, 2022, using the standard weekend days.<\/td>\nMay 25, 2022<\/td>\n<\/tr>\n
    =WORKDAY.INTL(\"6\/1\/2022\", 5, 11)<\/code><\/td>\nAdd 5 working days to June 1, 2022, with only Sunday counted as the weekend (code 11).<\/td>\nJune 8, 2022<\/td>\n<\/tr>\n
    =WORKDAY.INTL(\"6\/1\/2022\", 7, 1, B2:B6)<\/code><\/td>\nAdd 7 working days to June 1, 2022, while excluding the holidays listed in cells B2 to B6.<\/td>\nJune 10, 2022<\/td>\n<\/tr>\n<\/table>\n
    The examples provided showcase how the WORKDAY.INTL<\/strong> function can be adeptly used to manage deadlines, calculate project schedules, or adjust dates based on specific working day requirements by customizing weekend parameters and accounting for holidays.<\/p>\n
    With this powerful function, you can effectively manage timelines, gauge completion dates for tasks, and optimize your scheduling efforts in Excel and Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns the serial number of the date before or after a specified number of workdays 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-489","post","type-post","status-publish","format-standard","hentry","category-date-and-time"],"acf":[],"yoast_head":"\nExcel WORKDAY.INTL Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel WORKDAY.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\/workday-intl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel WORKDAY.INTL Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel WORKDAY.INTL function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/workday-intl\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:37:01+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel WORKDAY.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\/workday-intl\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/workday-intl\/\",\"name\":\"Excel WORKDAY.INTL Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-13T11:37:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel WORKDAY.INTL function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/workday-intl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/workday-intl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/workday-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\":\"WORKDAY.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 WORKDAY.INTL Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel WORKDAY.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\/workday-intl\/","og_locale":"en_US","og_type":"article","og_title":"Excel WORKDAY.INTL Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel WORKDAY.INTL function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/workday-intl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-13T11:37:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel WORKDAY.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\/workday-intl\/","url":"https:\/\/functiontranslator.com\/en\/workday-intl\/","name":"Excel WORKDAY.INTL Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-13T11:37:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel WORKDAY.INTL function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/workday-intl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/workday-intl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/workday-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":"WORKDAY.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\/489","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=489"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/489\/revisions"}],"predecessor-version":[{"id":3380,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/489\/revisions\/3380"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}