{"id":6489,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/jours\/"},"modified":"2021-02-26T08:04:27","modified_gmt":"2021-02-26T08:04:27","slug":"days","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/days\/","title":{"rendered":"JOURS"},"content":{"rendered":"

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

La fonction JOURS<\/strong> dans Excel et Google Sheets est con\u00e7ue pour calculer le nombre de jours qui s\u00e9parent deux dates. Elle se r\u00e9v\u00e8le particuli\u00e8rement utile pour analyser des p\u00e9riodes sp\u00e9cifiques, telles que la dur\u00e9e \u00e9coul\u00e9e entre deux \u00e9v\u00e9nements.<\/p>\n

Syntaxe de la fonction en Excel :<\/strong>
JOURS(fin, d\u00e9but)<\/code><\/p>\n

Syntaxe de la fonction dans Google Sheets :<\/strong>
JOURS(date_fin, date_d\u00e9but)<\/code><\/p>\n

Les param\u00e8tres fin<\/code> et date_fin<\/code> d\u00e9signent la date de fin, tandis que d\u00e9but<\/code> et date_d\u00e9but<\/code> indiquent la date de d\u00e9part. Ces dates doivent \u00eatre saisies sous forme de cha\u00eenes de texte valides ou r\u00e9sultant d’autres formules ou fonctions.<\/p>\n

Exemples d’utilisation de base<\/h2>\n\n\n\n\n
Date d\u00e9but<\/th>\nDate fin<\/th>\nFormule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
01\/01\/2020<\/td>\n31\/12\/2020<\/td>\n=JOURS(\"31\/12\/2020\";\"01\/01\/2020\")<\/code><\/td>\n365<\/td>\n<\/tr>\n
15\/05\/2021<\/td>\n20\/05\/2021<\/td>\n=JOURS(\"20\/05\/2021\";\"15\/05\/2021\")<\/code><\/td>\n5<\/td>\n<\/tr>\n<\/table>\n

Sc\u00e9narios pratiques<\/h2>\n

Examinons maintenant quelques cas d’application de la fonction JOURS<\/strong> pour illustrer sa polyvalence.<\/p>\n

    \n
  • Calculer le nombre de jours de travail d’un projet :<\/strong> Pour planifier efficacement, il est essentiel de conna\u00eetre le nombre total de jours ouvr\u00e9s entre le d\u00e9but et la fin d’un projet.\n
    Date de D\u00e9but: 01\/03\/2023 Date de Fin: 01\/06\/2023 Formule: =JOURS(\"01\/06\/2023\", \"01\/03\/2023\")<\/code><\/pre>\n
     Ce calcul retourne 92 jours, offrant une vision claire de la dur\u00e9e totale du projet.<\/li>\n
  • \u00c9valuer le temps restant jusqu’\u00e0 un \u00e9v\u00e9nement futur:<\/strong> Supposons que vous organisiez un \u00e9v\u00e9nement sp\u00e9cial et souhaitiez d\u00e9terminer le nombre de jours restants.\n
    Date de l'\u00e9v\u00e9nement: 25\/12\/2023 Formule: =JOURS(\"25\/12\/2023\", AUJOURDHUI())<\/code><\/pre>\n
     Cette formule vous indique le nombre de jours restants jusqu’au 25 d\u00e9cembre 2023.<\/li>\n<\/ul>\n
    En exploitant ces exemples, on peut adapter la fonction JOURS<\/strong> \u00e0 une grande vari\u00e9t\u00e9 de situations, que ce soit pour la gestion du temps au quotidien, le calcul de p\u00e9riodes ou la planification d’\u00e9v\u00e9nements, tant sur le plan personnel que professionnel.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le nombre de jours entre deux dates<\/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-6489","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction DAYS (JOURS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DAYS (JOURS) 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\/days\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DAYS (JOURS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DAYS (JOURS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/days\/\" \/>\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:04:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DAYS (JOURS) 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\/days\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/days\/\",\"name\":\"Fonction DAYS (JOURS) 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:04:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DAYS (JOURS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/days\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/days\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/days\/#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\":\"JOURS\"}]},{\"@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 DAYS (JOURS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DAYS (JOURS) 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\/days\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DAYS (JOURS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DAYS (JOURS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/days\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DAYS (JOURS) 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\/days\/","url":"https:\/\/functiontranslator.com\/fr\/days\/","name":"Fonction DAYS (JOURS) 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:04:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DAYS (JOURS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/days\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/days\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/days\/#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":"JOURS"}]},{"@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\/6489","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=6489"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6489\/revisions"}],"predecessor-version":[{"id":29501,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6489\/revisions\/29501"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}