{"id":6464,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/nb-jours-coupons\/"},"modified":"2021-02-26T08:03:46","modified_gmt":"2021-02-26T08:03:46","slug":"coupdays","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/coupdays\/","title":{"rendered":"NB.JOURS.COUPONS"},"content":{"rendered":"

Description g\u00e9n\u00e9rale<\/h2>\n

La fonction NB.JOURS.COUPONS<\/code> dans Microsoft Excel et Google Sheets calcule le nombre total de jours dans la p\u00e9riode de coupon courante pour une obligation sp\u00e9cifique. Cette fonction est particuli\u00e8rement utile pour analyser les investissements en obligations, car elle permet de d\u00e9terminer la dur\u00e9e des p\u00e9riodes de paiement des int\u00e9r\u00eats.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction NB.JOURS.COUPONS<\/code> est :<\/p>\n

NB.JOURS.COUPONS(settlement, maturity, frequency, [basis])<\/code><\/pre>\n
    \n
  • settlement<\/strong> : la date de r\u00e8glement de l’obligation, c’est-\u00e0-dire la date \u00e0 laquelle l’achat de l’obligation devient effectif.<\/li>\n
  • maturity<\/strong> : la date \u00e0 laquelle l’obligation arrive \u00e0 \u00e9ch\u00e9ance.<\/li>\n
  • frequency<\/strong> : le nombre de fois o\u00f9 l’int\u00e9r\u00eat du coupon est pay\u00e9 par an (1, 2 ou 4).<\/li>\n
  • basis<\/strong> (facultatif) : la m\u00e9thode utilis\u00e9e pour calculer le nombre de jours (0 = 30\/360, 1 = r\u00e9el\/r\u00e9el, 2 = r\u00e9el\/360, 3 = r\u00e9el\/365, 4 = Europe 30\/360).<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Pour calculer le nombre de jours dans la p\u00e9riode de coupon actuelle d’une obligation avec une date de r\u00e8glement le 01\/04\/2023 et une date d’\u00e9ch\u00e9ance le 01\/04\/2033, avec des paiements semestriels, la syntaxe serait :<\/p>\n
    =NB.JOURS.COUPONS(\"01\/04\/2023\", \"01\/04\/2033\", 2)<\/code><\/pre>\n
    Sc\u00e9narios Pratiques<\/h2>\n
    T\u00e2che 1 : Calcul du nombre de jours de coupon pour une obligation trimestrielle<\/h2>\n
    Consid\u00e9rez une obligation acquise le 15\/05\/2023 qui arrivera \u00e0 \u00e9ch\u00e9ance le 15\/05\/2028, avec des coupons pay\u00e9s chaque trimestre. Ce calcul permet de d\u00e9terminer la dur\u00e9e de chaque p\u00e9riode de paiement des coupons.<\/p>\n
    Solution :<\/p>\n
    =NB.JOURS.COUPONS(\"15\/05\/2023\", \"15\/05\/2028\", 4)<\/code><\/pre>\n
    Cette formule d\u00e9termine le nombre de jours dans la p\u00e9riode de coupon actuelle, bas\u00e9 sur la m\u00e9thode standard 30\/360.<\/p>\n
    T\u00e2che 2 : Analyse d’une obligation avec paiements annuels<\/h2>\n
    Pour une obligation dont la date de r\u00e8glement est le 01\/01\/2023 et la date d’\u00e9ch\u00e9ance le 01\/01\/2033, avec des paiements annuels, il est n\u00e9cessaire de conna\u00eetre la dur\u00e9e de chaque p\u00e9riode de coupon.<\/p>\n
    Solution :<\/p>\n
    =NB.JOURS.COUPONS(\"01\/01\/2023\", \"01\/01\/2033\", 1, 1)<\/code><\/pre>\n
    En optant pour la base \u00ab\u00a0r\u00e9el\/r\u00e9el\u00a0\u00bb (valeur 1 pour le quatri\u00e8me param\u00e8tre), cette formule fournit le nombre exact de jours entre les dates de d\u00e9but et de fin de chaque p\u00e9riode de coupon.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le nombRe de jouRs pouR la p\u00e9Riode du coupon contenant la date de liquidation<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[311],"tags":[],"class_list":["post-6464","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction COUPDAYS (NB.JOURS.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUPDAYS (NB.JOURS.COUPONS) 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\/coupdays\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUPDAYS (NB.JOURS.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUPDAYS (NB.JOURS.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/coupdays\/\" \/>\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:03:46+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUPDAYS (NB.JOURS.COUPONS) 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\/coupdays\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/coupdays\/\",\"name\":\"Fonction COUPDAYS (NB.JOURS.COUPONS) 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:03:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUPDAYS (NB.JOURS.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupdays\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/coupdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupdays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finances\",\"item\":\"https:\/\/functiontranslator.com\/fr\/finances\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NB.JOURS.COUPONS\"}]},{\"@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 COUPDAYS (NB.JOURS.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUPDAYS (NB.JOURS.COUPONS) 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\/coupdays\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUPDAYS (NB.JOURS.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUPDAYS (NB.JOURS.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/coupdays\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUPDAYS (NB.JOURS.COUPONS) 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\/coupdays\/","url":"https:\/\/functiontranslator.com\/fr\/coupdays\/","name":"Fonction COUPDAYS (NB.JOURS.COUPONS) 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:03:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUPDAYS (NB.JOURS.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/coupdays\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/coupdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/coupdays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Finances","item":"https:\/\/functiontranslator.com\/fr\/finances\/"},{"@type":"ListItem","position":3,"name":"NB.JOURS.COUPONS"}]},{"@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\/6464","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=6464"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6464\/revisions"}],"predecessor-version":[{"id":29476,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6464\/revisions\/29476"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}