{"id":6840,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/joursem\/"},"modified":"2021-02-26T08:16:16","modified_gmt":"2021-02-26T08:16:16","slug":"weekday","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/weekday\/","title":{"rendered":"JOURSEM"},"content":{"rendered":"

Introduction \u00e0 la fonction JOURSEM<\/h2>\n

La fonction JOURSEM, disponible dans Excel et Google Sheets, est utilis\u00e9e pour d\u00e9terminer le jour de la semaine associ\u00e9 \u00e0 une date donn\u00e9e. Elle renvoie un nombre correspondant \u00e0 ce jour. Cette fonction s’av\u00e8re tr\u00e8s utile pour l’analyse des donn\u00e9es temporelles, particuli\u00e8rement dans les contextes o\u00f9 les jours sp\u00e9cifiques sont cruciaux pour les activit\u00e9s commerciales, \u00e9ducatives, ou autres.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

=JOURSEM(date, [type])<\/code><\/pre>\n
    \n
  • date<\/strong> : La date pour laquelle vous souhaitez conna\u00eetre le jour de la semaine. Cet argument doit \u00eatre une date valide ou une r\u00e9f\u00e9rence \u00e0 une cellule qui contient une date valide.<\/li>\n
  • type<\/strong> : Un argument num\u00e9rique optionnel qui d\u00e9finit la m\u00e9thode de calcul du num\u00e9ro du jour de la semaine. En l’absence de cet argument, la valeur par d\u00e9faut est 1, signifiant que la semaine d\u00e9bute le dimanche (1 = Dimanche, …, 7 = Samedi).<\/li>\n<\/ul>\n
    Les options pour l’argument type<\/em> sont les suivantes :<\/p>\n\n\n\n\n\n
    Type<\/th>\nDescription<\/th>\n<\/tr>\n
    1 ou absence<\/td>\nLes semaines d\u00e9butent le dimanche (1)<\/td>\n<\/tr>\n
    2<\/td>\nLes semaines d\u00e9butent le lundi (1)<\/td>\n<\/tr>\n
    3<\/td>\nLes semaines d\u00e9butent le lundi (0)<\/td>\n<\/tr>\n<\/table>\n
    Exemples d’utilisation<\/h2>\n
    Voici quelques exemples pratiques pour illustrer l’utilisation de la fonction JOURSEM :<\/p>\n
    =JOURSEM(\"2023-11-15\") \/\/ R\u00e9sultat : 4 (Mercredi) =JOURSEM(\"2023-11-15\", 2) \/\/ R\u00e9sultat : 3 (Mercredi, avec lundi comme premier jour de la semaine) =JOURSEM(A1, 3) \/\/ Supposons que A1 contienne la date \"2023-11-15\", R\u00e9sultat : 2<\/code><\/pre>\n
    Sc\u00e9narios d’utilisation pratique<\/h2>\n
    Planification d’un calendrier \u00e9ditorial<\/h2>\n
    Dans le secteur des m\u00e9dias, la fonction JOURSEM peut \u00eatre utilis\u00e9e pour programmer des publications selon le jour de la semaine. Par exemple, pour garantir que certains contenus ne sont publi\u00e9s qu’en semaine :<\/p>\n
    Si JOURSEM(A2, 2) < 6 \"Publier l'article\" Sinon \"Ne pas publier\"<\/code><\/pre>\n
    O\u00f9 A2<\/em> est la cellule contenant la date de publication envisag\u00e9e.<\/p>\n
    Analyse des tendances de vente hebdomadaires<\/h2>\n
    Les d\u00e9taillants peuvent se servir de JOURSEM pour examiner les ventes en fonction du jour de la semaine et ajuster les promotions en cons\u00e9quence. Exemple :<\/p>\n
    =SOMME.SI(Ensemble_Dates; JOURSEM(Ensemble_Dates, 2) = 5; Ensemble_Ventes)<\/code><\/pre>\n
    Cette formule permet de calculer la vente totale pour les vendredis (consid\u00e9rant que le lundi est le premier jour de la semaine) en utilisant l'ensemble des dates de vente dans la plage Ensemble_Dates<\/em> et les sommes correspondantes dans Ensemble_Ventes<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Convertit un num\u00e9ro de s\u00e9rie en jour de la semaine<\/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-6840","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction WEEKDAY (JOURSEM) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction WEEKDAY (JOURSEM) 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\/weekday\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction WEEKDAY (JOURSEM) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction WEEKDAY (JOURSEM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/weekday\/\" \/>\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:16:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction WEEKDAY (JOURSEM) 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\/weekday\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/weekday\/\",\"name\":\"Fonction WEEKDAY (JOURSEM) 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:16:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction WEEKDAY (JOURSEM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/weekday\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/weekday\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/weekday\/#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\":\"JOURSEM\"}]},{\"@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 WEEKDAY (JOURSEM) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction WEEKDAY (JOURSEM) 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\/weekday\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction WEEKDAY (JOURSEM) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction WEEKDAY (JOURSEM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/weekday\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction WEEKDAY (JOURSEM) 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\/weekday\/","url":"https:\/\/functiontranslator.com\/fr\/weekday\/","name":"Fonction WEEKDAY (JOURSEM) 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:16:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction WEEKDAY (JOURSEM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/weekday\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/weekday\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/weekday\/#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":"JOURSEM"}]},{"@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\/6840","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=6840"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6840\/revisions"}],"predecessor-version":[{"id":29849,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6840\/revisions\/29849"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}