{"id":6517,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/mois-decaler\/"},"modified":"2021-02-26T08:05:34","modified_gmt":"2021-02-26T08:05:34","slug":"edate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/edate\/","title":{"rendered":"MOIS.DECALER"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction EDATE, nomm\u00e9e MOIS.DECALER en fran\u00e7ais, est employ\u00e9e dans Excel et Google Sheets pour calculer une date situ\u00e9e un certain nombre de mois avant ou apr\u00e8s une date initiale sp\u00e9cifi\u00e9e. Cette fonction trouve son utilit\u00e9 dans divers domaines tels que la gestion financi\u00e8re, la planification de projets, ainsi que d’autres secteurs o\u00f9 la manipulation de dates est n\u00e9cessaire.<\/p>\n

Syntaxe :<\/p>\n

MOIS.DECALER(date_d\u00e9part, mois)<\/code><\/pre>\n
    \n
  • date_d\u00e9part<\/strong> : Correspond \u00e0 la date de r\u00e9f\u00e9rence pour le calcul. Cette date doit \u00eatre saisie comme une date valide ou peut \u00eatre le r\u00e9sultat d’autres fonctions de date.<\/li>\n
  • mois<\/strong> : Indique le nombre de mois \u00e0 ajouter \u00e0 la date de d\u00e9part. Un nombre positif d\u00e9cale la date vers le futur, tandis qu\u2019un nombre n\u00e9gatif la r\u00e9trograde.<\/li>\n<\/ul>\n
    Exemples concrets<\/h2>\n
    Prenons l’exemple de la n\u00e9cessit\u00e9 de d\u00e9terminer les dates de paiement pour des abonnements ou projets mensuels. Voici comment utiliser efficacement la fonction MOIS.DECALER :<\/p>\n\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    MOIS.DECALER(\"2023-01-01\", 1)<\/code><\/td>\nAjoute un mois \u00e0 la date du 1er janvier 2023.<\/td>\n1er f\u00e9vrier 2023<\/td>\n<\/tr>\n
    MOIS.DECALER(\"2023-01-01\", -2)<\/code><\/td>\nRetire deux mois \u00e0 la date du 1er janvier 2023.<\/td>\n1er novembre 2022<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios d’application pratique<\/h2>\n
    Explorons deux exemples pratiques o\u00f9 la fonction MOIS.DECALER peut \u00eatre extr\u00eamement b\u00e9n\u00e9fique.<\/p>\n
    Calcul de la date d’\u00e9ch\u00e9ance pour une facturation r\u00e9currente<\/h2>\n
    Imaginez que vous g\u00e9rez une entreprise proposant des abonnements qui d\u00e9butent le 15 janvier 2023, et vous voulez conna\u00eetre les dates de paiement pour les 12 mois suivants.<\/p>\n
      MOIS.DECALER(\"2023-01-15\", 1) -> 15 f\u00e9vrier 2023 MOIS.DECALER(\"2023-01-15\", 2) -> 15 mars 2023 MOIS.DECALER(\"2023-01-15\", 3) -> 15 avril 2023 ainsi de suite jusqu'\u00e0: MOIS.DECALER(\"2023-01-15\", 12) -> 15 janvier 2024 <\/code> <\/pre>\n
    Cela permet une planification claire et efficace de toutes les futures dates de facturation.<\/p>\n
    Planification des contr\u00f4les de maintenance<\/h2>\n
    Si vous avez des \u00e9quipements n\u00e9cessitant un entretien semestriel, vous pouvez d\u00e9terminer la prochaine date de maintenance en partant de la date de la derni\u00e8re intervention.<\/p>\n
      Date de derni\u00e8re maintenance : 1er juin 2022 MOIS.DECALER(\"2022-06-01\", 6) -> 1er d\u00e9cembre 2022 <\/code> <\/pre>\n
    Cette application de la fonction vous assure de ne jamais oublier les dates critiques de maintenance pr\u00e9ventive.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le num\u00e9Ro de s\u00e9Rie de la date qui RepR\u00e9sente une date sp\u00e9cifi\u00e9e (l\u2019aRgument date_d\u00e9paRt), coRRig\u00e9e en plus ou en moins du nombRe de mois indiqu\u00e9<\/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-6517","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction EDATE (MOIS.DECALER) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction EDATE (MOIS.DECALER) 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\/edate\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction EDATE (MOIS.DECALER) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction EDATE (MOIS.DECALER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/edate\/\" \/>\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:05:34+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction EDATE (MOIS.DECALER) 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\/edate\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/edate\/\",\"name\":\"Fonction EDATE (MOIS.DECALER) 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:05:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction EDATE (MOIS.DECALER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/edate\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/edate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/edate\/#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\":\"MOIS.DECALER\"}]},{\"@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 EDATE (MOIS.DECALER) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction EDATE (MOIS.DECALER) 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\/edate\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction EDATE (MOIS.DECALER) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction EDATE (MOIS.DECALER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/edate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction EDATE (MOIS.DECALER) 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\/edate\/","url":"https:\/\/functiontranslator.com\/fr\/edate\/","name":"Fonction EDATE (MOIS.DECALER) 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:05:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction EDATE (MOIS.DECALER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/edate\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/edate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/edate\/#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":"MOIS.DECALER"}]},{"@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\/6517","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=6517"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6517\/revisions"}],"predecessor-version":[{"id":29529,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6517\/revisions\/29529"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}