{"id":6490,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/jours360\/"},"modified":"2021-02-26T08:04:28","modified_gmt":"2021-02-26T08:04:28","slug":"days360","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/days360\/","title":{"rendered":"JOURS360"},"content":{"rendered":"

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

La fonction JOURS360<\/code> dans Microsoft Excel et Google Sheets est con\u00e7ue pour calculer le nombre de jours entre deux dates, en utilisant une ann\u00e9e standardis\u00e9e de 360 jours constitu\u00e9e de douze mois de 30 jours chacun. Cette m\u00e9thode de calcul est fr\u00e9quemment utilis\u00e9e dans les environnements financiers pour faciliter le calcul des int\u00e9r\u00eats annuels.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe de la fonction JOURS360<\/code> est la suivante :<\/p>\n

JOURS360(date_d\u00e9but, date_fin, [m\u00e9thode])<\/code><\/pre>\n
    \n
  • date_d\u00e9but<\/strong> : La date marquant le d\u00e9but de la p\u00e9riode.<\/li>\n
  • date_fin<\/strong> : La date marquant la fin de la p\u00e9riode.<\/li>\n
  • m\u00e9thode<\/strong> (optionnel) : Un param\u00e8tre bool\u00e9en o\u00f9 la valeur FALSE (ou la valeur omise) indique l’usage de la m\u00e9thode am\u00e9ricaine (NASD), et TRUE signifie l’adoption de la m\u00e9thode europ\u00e9enne.<\/li>\n<\/ul>\n
    Voici un exemple d’application :<\/p>\n
    =JOURS360(\"01\/01\/2023\", \"31\/12\/2023\")<\/code><\/pre>\n
    Cette formule renvoie 360<\/strong>, calculant ainsi le nombre de jours entre le 1er janvier et le 31 d\u00e9cembre sur la base d\u2019une ann\u00e9e de 360 jours.<\/p>\n
    Sc\u00e9narios d’utilisation<\/h2>\n
    Calcul d’int\u00e9r\u00eats sur un pr\u00eat<\/h3>\n
    Si vous avez souscrit un pr\u00eat dont les int\u00e9r\u00eats sont calcul\u00e9s sur une base de 360 jours, vous pouvez utiliser JOURS360<\/code> pour d\u00e9terminer les int\u00e9r\u00eats \u00e0 payer. Par exemple, pour un pr\u00eat du 1er mars 2023 au 1er mars 2024 avec un taux d’int\u00e9r\u00eat de 5%, utilisez :<\/p>\n
    =JOURS360(\"01\/03\/2023\", \"01\/03\/2024\") * 5% * montant_du_pr\u00eat<\/code><\/pre>\n
    Cette formule vous permet de calculer les int\u00e9r\u00eats dus sur une ann\u00e9e compl\u00e8te.<\/p>\n
    Comparaison du nombre de jours travaill\u00e9s entre diff\u00e9rentes ann\u00e9es<\/h3>\n
    Pour comparer effectivement le nombre de jours de travail entre deux ann\u00e9es distinctes, tout en prenant en compte les jours f\u00e9ri\u00e9s et les cong\u00e9s, la fonction JOURS360<\/code> peut \u00eatre tr\u00e8s utile. Par exemple :<\/p>\n
    Variable1 = JOURS360(\"01\/01\/2022\", \"31\/12\/2022\") - Nombre_de_jours_non_ouvr\u00e9s_2022 Variable2 = JOURS360(\"01\/01\/2023\", \"31\/12\/2023\") - Nombre_de_jours_non_ouvr\u00e9s_2023 Diff\u00e9rence = Variable2 - Variable1<\/code><\/pre>\n
    Ce calcul vous montrera la variation du nombre de jours travaill\u00e9s entre ces deux ann\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule le nombre de jours qui s\u00e9parent deux dates sur la base d\u2019une ann\u00e9e de 360\u00a0jours<\/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-6490","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction DAYS360 (JOURS360) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DAYS360 (JOURS360) 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\/days360\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DAYS360 (JOURS360) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DAYS360 (JOURS360) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/days360\/\" \/>\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:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DAYS360 (JOURS360) 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\/days360\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/days360\/\",\"name\":\"Fonction DAYS360 (JOURS360) 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:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DAYS360 (JOURS360) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/days360\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/days360\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/days360\/#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\":\"JOURS360\"}]},{\"@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 DAYS360 (JOURS360) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DAYS360 (JOURS360) 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\/days360\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DAYS360 (JOURS360) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DAYS360 (JOURS360) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/days360\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DAYS360 (JOURS360) 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\/days360\/","url":"https:\/\/functiontranslator.com\/fr\/days360\/","name":"Fonction DAYS360 (JOURS360) 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:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DAYS360 (JOURS360) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/days360\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/days360\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/days360\/#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":"JOURS360"}]},{"@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\/6490","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=6490"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6490\/revisions"}],"predecessor-version":[{"id":29502,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6490\/revisions\/29502"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}