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

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

La fonction permettant de calculer le mois \u00e0 partir d’une date est cruciale pour la manipulation des donn\u00e9es temporelles dans Excel et Google Sheets. Elle extrait le num\u00e9ro du mois de la date indiqu\u00e9e, \u00e9l\u00e9ment essentiel pour les analyses temporelles, la gestion financi\u00e8re et la planification.<\/p>\n

Description et syntaxe<\/h2>\n

La syntaxe de cette fonction est simple et se pr\u00e9sente comme suit :<\/p>\n

 =MOIS(date)<\/code> <\/pre>\n
Dans cette formule, date<\/code> doit \u00eatre une r\u00e9f\u00e9rence de cellule contenant une date, une date entr\u00e9e directement en tant que texte (comme \u00ab\u00a02023-01-01\u00a0\u00bb) ou le r\u00e9sultat d’autres fonctions ou calculs qui retournent une date.<\/p>\n
Exemples pratiques d’utilisation<\/h2>\n
    \n
  • Extraction du mois :<\/b> Dans une cellule A1 contenant la date \u00ab\u00a015\/04\/2023\u00a0\u00bb, la formule =MOIS(A1)<\/code> renverra \u00ab\u00a04\u00a0\u00bb, car avril est le quatri\u00e8me mois de l’ann\u00e9e.<\/li>\n
  • Date en texte :<\/b> En utilisant la formule =MOIS(\"2023-12-25\")<\/code>, vous obtiendrez \u00ab\u00a012\u00a0\u00bb, indiquant que la date correspond au mois de d\u00e9cembre.<\/li>\n<\/ul>\n
    Sc\u00e9narios d’application<\/h2>\n
    1. Analyse financi\u00e8re par mois<\/h3>\n
    Probl\u00e8me :<\/b> Vous disposez d’une liste de transactions financi\u00e8res avec leurs dates et vous souhaitez analyser le volume de transactions mensuelles.<\/p>\n
    Solution :<\/b> Utilisez la fonction pour d\u00e9terminer le mois de chaque transaction, puis employez des fonctions de sommation ou de comptage conditionnel telles que SOMME.SI<\/code> ou NB.SI<\/code> pour les calculs.<\/p>\n
      Colonne A : Dates des transactions Colonne B : Montant des transactions Colonne C : =MOIS(A2) \/\/ Extrait le mois Colonne D : =NB.SI(C:C, \"4\") \/\/ Compte les transactions d'avril <\/code> <\/pre>\n
    2. Planification d’\u00e9v\u00e8nements<\/h3>\n
    Probl\u00e8me :<\/b> Vous \u00eates responsable de planifier les \u00e9v\u00e9nements pour une entreprise et devez \u00e9tablir un calendrier qui refl\u00e8te la fr\u00e9quence des \u00e9v\u00e9nements par mois.<\/p>\n
    Solution :<\/b> Listez tous les \u00e9v\u00e9nements avec leurs dates dans une feuille de calcul et utilisez la fonction pour organiser ces \u00e9v\u00e9nements par mois.<\/p>\n
      Colonne A : Dates des \u00e9v\u00e9nements Colonne B : Noms des \u00e9v\u00e9nements Colonne C : =MOIS(A2) \/\/ Extrait le mois pour chaque \u00e9v\u00e9nement <\/code> <\/pre>\n
    Ces informations peuvent \u00eatre alors utilis\u00e9es pour cr\u00e9er des sommaires ou des graphiques qui illustrent la distribution mensuelle des \u00e9v\u00e9nements.<\/p>\n
    Conclusion<\/h2>\n
    La fonction MOIS simplifie l’analyse des donn\u00e9es chronologiques en isolant le mois, ce qui facilite la gestion et l’organisation d’activit\u00e9s bas\u00e9es sur des p\u00e9riodes mensuelles. Elle s’av\u00e8re indispensable pour des applications telles que l’analyse financi\u00e8re et la planification d’\u00e9v\u00e9nements, parmi d’autres usages n\u00e9cessitant une manipulation avanc\u00e9e des donn\u00e9es temporelles.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Convertit un num\u00e9ro de s\u00e9rie en mois<\/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-6673","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction MONTH (MOIS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MONTH (MOIS) 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\/month\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MONTH (MOIS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MONTH (MOIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/month\/\" \/>\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:10:37+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MONTH (MOIS) 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\/month\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/month\/\",\"name\":\"Fonction MONTH (MOIS) 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:10:37+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MONTH (MOIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/month\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/month\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/month\/#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\"}]},{\"@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 MONTH (MOIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MONTH (MOIS) 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\/month\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MONTH (MOIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MONTH (MOIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/month\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:37+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MONTH (MOIS) 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\/month\/","url":"https:\/\/functiontranslator.com\/fr\/month\/","name":"Fonction MONTH (MOIS) 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:10:37+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MONTH (MOIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/month\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/month\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/month\/#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"}]},{"@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\/6673","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=6673"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6673\/revisions"}],"predecessor-version":[{"id":29684,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6673\/revisions\/29684"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}