{"id":6682,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/nb-jours-ouvres-intl\/"},"modified":"2021-02-26T08:10:53","modified_gmt":"2021-02-26T08:10:53","slug":"networkdays-intl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/","title":{"rendered":"NB.JOURS.OUVRES.INTL"},"content":{"rendered":"

La fonction NETWORKDAYS.INTL<\/strong> dans Microsoft Excel et NB.JOURS.OUVRES.INTL<\/strong> dans Google Sheets permet de calculer le nombre de jours ouvrables entre deux dates, en tenant compte des week-ends personnalis\u00e9s et des jours f\u00e9ri\u00e9s. Cette fonction est une extension de la fonction NETWORKDAYS, offrant ainsi plus de flexibilit\u00e9 dans la gestion du calendrier.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe g\u00e9n\u00e9rale de la fonction :<\/p>\n

=NETWORKDAYS.INTL(date_start, date_end, [weekend], [holidays])<\/code><\/pre>\n
    \n
  • date_start<\/strong> : La date de d\u00e9but de la p\u00e9riode. Ce param\u00e8tre est obligatoire.<\/li>\n
  • date_end<\/strong> : La date de fin de la p\u00e9riode. Ce param\u00e8tre est \u00e9galement obligatoire.<\/li>\n
  • weekend<\/strong> : Un num\u00e9ro ou une cha\u00eene de caract\u00e8res sp\u00e9cifiant les jours de week-end. Ce param\u00e8tre est optionnel.<\/li>\n
  • holidays<\/strong> : Un tableau contenant les dates des jours f\u00e9ri\u00e9s. Ce param\u00e8tre est \u00e9galement optionnel.<\/li>\n<\/ul>\n
    Configuration des week-ends<\/h2>\n
    Le param\u00e8tre weekend<\/strong> peut \u00eatre configur\u00e9 selon les modalit\u00e9s suivantes :<\/p>\n
      \n
    • En utilisant un num\u00e9ro entre 1 et 17 pour s\u00e9lectionner l’une des configurations pr\u00e9d\u00e9finies des jours de week-end.<\/li>\n
    • En utilisant une cha\u00eene de sept chiffres (compos\u00e9e de 0 et de 1) qui repr\u00e9sentent les jours de la semaine du lundi au dimanche. Un ‘1’ indique un jour de week-end et un ‘0’ un jour ouvrable. Par exemple, ‘0000011’ indique que le samedi et le dimanche sont des jours de week-end.<\/li>\n<\/ul>\n
      Exemples<\/h2>\n
      Examinons le cas o\u00f9 vous souhaitez calculer le nombre de jours ouvrables entre le 1er janvier 2024 et le 31 janvier 2024, avec le samedi et le dimanche comme jours de week-end, et sans inclure de jours f\u00e9ri\u00e9s :<\/p>\n
      =NETWORKDAYS.INTL(\"2024-01-01\", \"2024-01-31\")<\/code><\/pre>\n
      Cet exemple retournera 23, car il y a 23 jours ouvrables dans cette p\u00e9riode sans prendre en compte les week-ends.<\/p>\n
      Sc\u00e9narios pratiques<\/h2>\n
      Sc\u00e9nario 1:<\/strong> Planification des jours ouvrables pour un projet<\/p>\n
      Imaginons que vous devez planifier un projet commencant le 1er mars 2024 et se terminant le 30 mars 2024, avec vendredi et samedi comme jours de week-end, et le 21 mars comme jour f\u00e9ri\u00e9 :<\/p>\n
      =NETWORKDAYS.INTL(\"2024-03-01\", \"2024-03-30\", \"0001100\", \"2024-03-21\")<\/code><\/pre>\n
      Cette formule retournera 20, refl\u00e9tant le nombre de jours ouvrables, en tenant compte des jours sp\u00e9cifiques non ouvrables.<\/p>\n
      Sc\u00e9nario 2:<\/strong> \u00c9valuation de l’impact des jours f\u00e9ri\u00e9s sur la productivit\u00e9<\/p>\n
      Supposons que vous souhaitez analyser l’impact des jours f\u00e9ri\u00e9s sur la productivit\u00e9 du 1er janvier au 31 mars 2024. En prenant en compte les f\u00eates locales et en d\u00e9finissant des jours f\u00e9ri\u00e9s le 1er janvier, le 14 f\u00e9vrier, et le 8 mars, avec des week-ends classiques (samedi et dimanche) :<\/p>\n
      =NETWORKDAYS.INTL(\"2024-01-01\", \"2024-03-31\", \"0000011\", {\"2024-01-01\", \"2024-02-14\", \"2024-03-08\"})<\/code><\/pre>\n
      Cette formule calculera le nombre total de jours ouvrables en consid\u00e9rant les jours de non-travail sp\u00e9cifi\u00e9s.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le nombRe de jouRs ouvR\u00e9s entieRs compRis entRe deux dates \u00e0 l\u2019aide de paRam\u00e8tRes identifiant les jouRs du week-end et leuR nombRe<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[321],"tags":[],"class_list":["post-6682","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/networkdays-intl\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:10:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\/fr\/networkdays-intl\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/\",\"name\":\"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:10:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Date et heure\",\"item\":\"https:\/\/functiontranslator.com\/fr\/date-et-heure\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NB.JOURS.OUVRES.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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/networkdays-intl\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/","url":"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/","name":"Fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:10:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NETWORKDAYS.INTL (NB.JOURS.OUVRES.INTL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/networkdays-intl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/networkdays-intl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Date et heure","item":"https:\/\/functiontranslator.com\/fr\/date-et-heure\/"},{"@type":"ListItem","position":3,"name":"NB.JOURS.OUVRES.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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6682"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6682\/revisions"}],"predecessor-version":[{"id":29693,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6682\/revisions\/29693"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}