{"id":6466,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/date-coupon-suiv\/"},"modified":"2021-02-26T08:03:49","modified_gmt":"2021-02-26T08:03:49","slug":"coupncd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/coupncd\/","title":{"rendered":"DATE.COUPON.SUIV"},"content":{"rendered":"

Introduction \u00e0 la fonction de calcul de la date de coupon suivante<\/h2>\n

La fonction DATE.COUPON.SUIV (ou COUPNCD en anglais) est utilis\u00e9e dans Microsoft Excel et Google Sheets pour d\u00e9terminer la prochaine date de paiement d’un coupon pour un titre \u00e0 revenu fixe. Cette fonction est essentielle pour les gestionnaires de portefeuille, les analystes financiers et les investisseurs engag\u00e9s dans le suivi des dates de paiement des int\u00e9r\u00eats.<\/p>\n

Syntaxe et Param\u00e8tres<\/h2>\n

Voici la syntaxe de la fonction DATE.COUPON.SUIV :<\/p>\n

  DATE.COUPON.SUIV(date_\u00e9mission, date_\u00e9ch\u00e9ance, date_r\u00e9f\u00e9rence, fr\u00e9quence, [base]) <\/code> <\/pre>\n
    \n
  • date_\u00e9mission<\/strong> : La date \u00e0 laquelle le titre a \u00e9t\u00e9 \u00e9mis.<\/li>\n
  • date_\u00e9ch\u00e9ance<\/strong> : La date de fin de validit\u00e9 du titre.<\/li>\n
  • date_r\u00e9f\u00e9rence<\/strong> : La date utilis\u00e9e pour calculer la prochaine date de coupon.<\/li>\n
  • fr\u00e9quence<\/strong> : La fr\u00e9quence des paiements de coupon par an (1, 2 ou 4).<\/li>\n
  • base<\/strong> (facultatif) : Le syst\u00e8me de comptage des jours utilis\u00e9 (0 = 30\/360 US, 1 = r\u00e9el\/r\u00e9el, 2 = 30\/360 Eur., 3 = 30\/360 Eur. modifi\u00e9, 4 = 30\/360 Ital.), par d\u00e9faut 0 si non sp\u00e9cifi\u00e9.<\/li>\n<\/ul>\n
    Exemples Pratiques<\/h2>\n
    Illustrons l’utilisation de DATE.COUPON.SUIV avec des exemples concrets.<\/p>\n
    Cas Pratique 1: Calcul de la prochaine date de coupon pour un emprunt<\/h2>\n
    Supposons que vous poss\u00e9dez une obligation \u00e9mise le 1er janvier 2020, venant \u00e0 \u00e9ch\u00e9ance le 1er janvier 2030, et versant des coupons semestriels. Si nous sommes aujourd\u2019hui le 1er juillet 2023, et nous cherchons la prochaine date de paiement de coupon :<\/p>\n
      =DATE.COUPON.SUIV(\"01\/01\/2020\", \"01\/01\/2030\", \"01\/07\/2023\", 2) <\/code> <\/pre>\n
    Le r\u00e9sultat sera 01\/01\/2024<\/strong>. Ici, la fr\u00e9quence est 2, ce qui signifie que les coupons sont pay\u00e9s deux fois par an.<\/p>\n
    Cas Pratique 2: Utilisation avec diff\u00e9rentes bases de calcul des jours<\/h2>\n
    Consid\u00e9rons maintenant que la m\u00eame obligation utilise une convention diff\u00e9rente de comptage des jours en Europe. Utilisons la base 3 (30\/360 Eur. modifi\u00e9) :<\/p>\n
      =DATE.COUPON.SUIV(\"01\/01\/2020\", \"01\/01\/2030\", \"01\/07\/2023\", 2, 3) <\/code> <\/pre>\n
    Bien que cette base peut influencer le calcul des int\u00e9r\u00eats, surtout en fin de mois, le r\u00e9sultat pour cet exemple restera 01\/01\/2024<\/strong>.<\/p>\n
    Conclusion<\/h2>\n
    La fonction DATE.COUPON.SUIV est vitale pour la gestion des portefeuilles d’obligations. Elle offre une m\u00e9thode efficace pour planifier et anticiper les flux de tr\u00e9sorerie futurs issus des paiements d’int\u00e9r\u00eats, contribuant ainsi au rendement global de l’investissement et s’assurant que aucun paiement de coupon n’est oubli\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pRemi\u00e8Re date de coupon ult\u00e9RieuRe \u00e0 la date de R\u00e8glement<\/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-6466","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction COUPNCD (DATE.COUPON.SUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUPNCD (DATE.COUPON.SUIV) 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\/coupncd\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUPNCD (DATE.COUPON.SUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUPNCD (DATE.COUPON.SUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/coupncd\/\" \/>\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:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUPNCD (DATE.COUPON.SUIV) 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\/coupncd\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/coupncd\/\",\"name\":\"Fonction COUPNCD (DATE.COUPON.SUIV) 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:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUPNCD (DATE.COUPON.SUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupncd\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/coupncd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupncd\/#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\":\"DATE.COUPON.SUIV\"}]},{\"@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 COUPNCD (DATE.COUPON.SUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUPNCD (DATE.COUPON.SUIV) 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\/coupncd\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUPNCD (DATE.COUPON.SUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUPNCD (DATE.COUPON.SUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/coupncd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUPNCD (DATE.COUPON.SUIV) 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\/coupncd\/","url":"https:\/\/functiontranslator.com\/fr\/coupncd\/","name":"Fonction COUPNCD (DATE.COUPON.SUIV) 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:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUPNCD (DATE.COUPON.SUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/coupncd\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/coupncd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/coupncd\/#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":"DATE.COUPON.SUIV"}]},{"@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\/6466","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=6466"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6466\/revisions"}],"predecessor-version":[{"id":29478,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6466\/revisions\/29478"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}