{"id":6844,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/serie-jour-ouvre\/"},"modified":"2021-02-26T08:16:22","modified_gmt":"2021-02-26T08:16:22","slug":"workday","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/workday\/","title":{"rendered":"SERIE.JOUR.OUVRE"},"content":{"rendered":"

La fonction SERIE.JOUR.OUVRE<\/strong> dans Microsoft Excel, \u00e9galement connue sous le nom WORKDAY<\/strong> en anglais, est essentielle pour le calcul des dates dans un contexte professionnel. Elle permet notamment de d\u00e9terminer une date d’\u00e9ch\u00e9ance, de planifier des \u00e9v\u00e9nements en fonction du calendrier de travail ou de compter les jours ouvrables entre deux dates donn\u00e9es.<\/p>\n

Pr\u00e9sentation de la fonction<\/h2>\n

La fonction SERIE.JOUR.OUVRE<\/code> calcule une date future ou pass\u00e9e en additionnant ou soustrayant un nombre sp\u00e9cifi\u00e9 de jours ouvrables \u00e0 une date de d\u00e9part, tout en excluant les week-ends et les jours f\u00e9ri\u00e9s facultatifs.<\/p>\n

 SERIE.JOUR.OUVRE(date_d\u00e9part; jours; [jours_f\u00e9ri\u00e9s])<\/code> <\/pre>\n
    \n
  • date_d\u00e9part<\/strong> : Il s’agit de la date de d\u00e9part pour le calcul. Cette date doit \u00eatre valide dans Excel.<\/li>\n
  • jours<\/strong> : Le nombre de jours ouvrables \u00e0 ajouter (si positif) ou \u00e0 soustraire (si n\u00e9gatif) \u00e0 partir de la date_d\u00e9part<\/code>.<\/li>\n
  • [jours_f\u00e9ri\u00e9s]<\/strong> (optionnel) : Correspond \u00e0 une plage de cellules contenant les dates qui doivent \u00eatre consid\u00e9r\u00e9es comme non ouvrables, en plus des week-ends.<\/li>\n<\/ul>\n
    Exemples de formules<\/h2>\n
    Supposez que vous initiez un projet le 1er janvier 2023 et que vous avez besoin de d\u00e9terminer une \u00e9ch\u00e9ance apr\u00e8s 10 jours ouvrables, sans inclure les week-ends ni les jours f\u00e9ri\u00e9s.<\/p>\n\n\n\n\n\n
    Date de d\u00e9part<\/th>\n01\/01\/2023<\/td>\n<\/tr>\n
    Jours ouvrables \u00e0 ajouter<\/th>\n10<\/td>\n<\/tr>\n
    Formule<\/th>\n=SERIE.JOUR.OUVRE(\u00ab\u00a02023-01-01\u00a0\u00bb; 10)<\/td>\n<\/tr>\n
    R\u00e9sultat<\/th>\n15\/01\/2023<\/td>\n<\/tr>\n<\/table>\n
    Applications pratiques<\/h2>\n
    Exemple 1 : Planification d’une livraison<\/h3>\n
    Imaginons qu’une entreprise doive planifier une livraison 15 jours ouvrables apr\u00e8s la r\u00e9ception d’une commande effectu\u00e9e le 15 mars 2023, tout en tenant compte des jours f\u00e9ri\u00e9s des 7 et 10 avril.<\/p>\n
     Date de la commande: 15\/03\/2023 Jours ouvrables jusqu'\u00e0 la livraison: 15 Jours f\u00e9ri\u00e9s: 7\/04\/2023, 10\/04\/2023 Formule utilis\u00e9e: =SERIE.JOUR.OUVRE(\"2023-03-15\"; 15; {\"2023-04-07\", \"2023-04-10\"}) Date de livraison pr\u00e9vue: 12\/04\/2023<\/code> <\/pre>\n
    Exemple 2 : Calcul de la dur\u00e9e d\u2019un processus administratif<\/h3>\n
    Une organisation n\u00e9cessite de d\u00e9terminer combien de temps prendra le traitement d’un dossier commenc\u00e9 le 2 mai 2023, n\u00e9cessitant 20 jours ouvrables, hors jours f\u00e9ri\u00e9s locaux du 18 et 25 mai.<\/p>\n
     Date de d\u00e9but: 02\/05\/2023 Dur\u00e9e en jours ouvrables: 20 Jours f\u00e9ri\u00e9s: 18\/05\/2023, 25\/05\/2023 Formule utilis\u00e9e: =SERIE.JOUR.OUVRE(\"2023-05-02\"; 20; {\"2023-05-18\", \"2023-05-25\"}) Date de fin du processus: 06\/06\/2023<\/code> <\/pre>\n
    La fonction SERIE.JOUR.OUVRE<\/code> est donc un outil pr\u00e9cieux pour la gestion du calendrier professionnel, permettant de naviguer efficacement parmi les contraintes des jours ouvrables et des jours f\u00e9ri\u00e9s.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le num\u00e9Ro de s\u00e9Rie de la date avant ou apR\u00e8s le nombRe de jouRs ouvR\u00e9s sp\u00e9cifi\u00e9s<\/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-6844","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction WORKDAY (SERIE.JOUR.OUVRE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction WORKDAY (SERIE.JOUR.OUVRE) 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\/workday\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction WORKDAY (SERIE.JOUR.OUVRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction WORKDAY (SERIE.JOUR.OUVRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/workday\/\" \/>\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:16:22+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction WORKDAY (SERIE.JOUR.OUVRE) 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\/workday\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/workday\/\",\"name\":\"Fonction WORKDAY (SERIE.JOUR.OUVRE) 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:16:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction WORKDAY (SERIE.JOUR.OUVRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/workday\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/workday\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/workday\/#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\":\"SERIE.JOUR.OUVRE\"}]},{\"@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 WORKDAY (SERIE.JOUR.OUVRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction WORKDAY (SERIE.JOUR.OUVRE) 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\/workday\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction WORKDAY (SERIE.JOUR.OUVRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction WORKDAY (SERIE.JOUR.OUVRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/workday\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction WORKDAY (SERIE.JOUR.OUVRE) 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\/workday\/","url":"https:\/\/functiontranslator.com\/fr\/workday\/","name":"Fonction WORKDAY (SERIE.JOUR.OUVRE) 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:16:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction WORKDAY (SERIE.JOUR.OUVRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/workday\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/workday\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/workday\/#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":"SERIE.JOUR.OUVRE"}]},{"@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\/6844","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=6844"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6844\/revisions"}],"predecessor-version":[{"id":29853,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6844\/revisions\/29853"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}