{"id":6486,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/dateval\/"},"modified":"2021-02-26T08:04:20","modified_gmt":"2021-02-26T08:04:20","slug":"datevalue","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/datevalue\/","title":{"rendered":"DATEVAL"},"content":{"rendered":"

La fonction DATEVALUE (ou DATEVAL en fran\u00e7ais) est utilis\u00e9e dans Microsoft Excel et Google Sheets pour convertir une date sous la forme texte en un num\u00e9ro de s\u00e9rie, format interne utilis\u00e9 par ces logiciels pour g\u00e9rer les dates. Cette fonction se r\u00e9v\u00e8le tr\u00e8s pratique lorsque vous devez traiter des dates provenant de syst\u00e8mes ou de formats externes qui ne les identifient pas automatiquement.<\/p>\n

Description de la syntaxe<\/h2>\n

Voici la syntaxe de la fonction :<\/p>\n

=DATEVALUE(texte_date)<\/code><\/pre>\n
    \n
  • texte_date<\/strong> : Il s’agit de la cha\u00eene de caract\u00e8res qui correspond \u00e0 une date dans un format que Excel ou Google Sheets peut reconna\u00eetre. Le format le plus fr\u00e9quemment utilis\u00e9 est \u00ab\u00a0JJ\/MM\/AAAA\u00a0\u00bb.<\/li>\n<\/ul>\n
    Exemple pratique :<\/strong><\/p>\n
    =DATEVALUE(\"01\/01\/2023\")<\/code><\/pre>\n
    Cette fonction transforme le texte de la date du 1er janvier 2023 en un num\u00e9ro de s\u00e9rie. Dans Excel, chaque jour \u00e0 partir du 1er janvier 1900 est converti en un num\u00e9ro de s\u00e9rie, le 1er janvier 1900 \u00e9tant repr\u00e9sent\u00e9 par le num\u00e9ro 1.<\/p>\n
    Applications pratiques<\/h2>\n
    La fonction DATEVALUE est extr\u00eamement utile pour diverses t\u00e2ches li\u00e9es \u00e0 la manipulation et \u00e0 l’analyse des dates en format texte.<\/p>\n
    Exemple 1 : Conversion de dates textuelles en format standard<\/h2>\n
    Supposez que vous disposiez d’une liste de dates en format texte que vous souhaitez convertir en format de date standard pour simplifier leur manipulation. Voici comment vous pouvez proc\u00e9der :<\/p>\n
    Cellule A1: \"23\/11\/2023\" Cellule A2: =DATEVALUE(A1)<\/code><\/pre>\n
    Excel ou Google Sheets affichera alors dans la cellule A2 le num\u00e9ro de s\u00e9rie correspondant \u00e0 la date indiqu\u00e9e, que vous pourrez ensuite formater en date standard via le menu de formatage des cellules.<\/p>\n
    Exemple 2 : Calcul de la diff\u00e9rence entre deux dates en utilisant DATEVALUE<\/h2>\n
    Imaginez que vous avez besoin de calculer le nombre de jours entre deux dates saisies en format texte. Voici comment utiliser DATEVALUE pour r\u00e9soudre ce probl\u00e8me :<\/p>\n
    Cellule A1: \"01\/01\/2023\" Cellule A2: \"31\/12\/2023\" Cellule A3: =DATEVALUE(A2) - DATEVALUE(A1)<\/code><\/pre>\n
    Le r\u00e9sultat dans la cellule A3 indiquera le nombre de jours entre le 1er janvier et le 31 d\u00e9cembre 2023.<\/p>\n
    Points importants \u00e0 retenir<\/h2>\n
      \n
    • La fonction DATEVALUE s’applique uniquement aux cha\u00eenes de texte qui repr\u00e9sentent des dates. Si la cha\u00eene de texte ne correspond pas \u00e0 une date valide, la fonction retournera une erreur.<\/li>\n
    • Le format de la date en texte doit \u00eatre conforme aux param\u00e8tres r\u00e9gionaux du syst\u00e8me ou du fichier Excel\/Google Sheets. Par exemple, le format \u00ab\u00a0MM\/DD\/YYYY\u00a0\u00bb est utilis\u00e9 aux \u00c9tats-Unis et \u00ab\u00a0DD\/MM\/YYYY\u00a0\u00bb dans de nombreux autres pays.<\/li>\n
    • Lors de l’utilisation de cette fonction dans Google Sheets, il est crucial que la localisation du document soit ajust\u00e9e pour correspondre au format de la date texte, faute de quoi la compr\u00e9hension de la date pourrait \u00eatre erron\u00e9e.<\/li>\n<\/ul>\n
      En r\u00e9sum\u00e9, la fonction DATEVALUE est un outil puissant pour g\u00e9rer des dates textuelles dans Excel et Google Sheets, facilitant une large gamme d’analyses et de manipulations de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Convertit une date repr\u00e9sent\u00e9e sous forme de texte en num\u00e9ro de s\u00e9rie<\/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-6486","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction DATEVALUE (DATEVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DATEVALUE (DATEVAL) 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\/datevalue\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DATEVALUE (DATEVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DATEVALUE (DATEVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/datevalue\/\" \/>\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:04:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DATEVALUE (DATEVAL) 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\/datevalue\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/datevalue\/\",\"name\":\"Fonction DATEVALUE (DATEVAL) 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:04:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DATEVALUE (DATEVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/datevalue\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/datevalue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/datevalue\/#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\":\"DATEVAL\"}]},{\"@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 DATEVALUE (DATEVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DATEVALUE (DATEVAL) 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\/datevalue\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DATEVALUE (DATEVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DATEVALUE (DATEVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/datevalue\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DATEVALUE (DATEVAL) 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\/datevalue\/","url":"https:\/\/functiontranslator.com\/fr\/datevalue\/","name":"Fonction DATEVALUE (DATEVAL) 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:04:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DATEVALUE (DATEVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/datevalue\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/datevalue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/datevalue\/#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":"DATEVAL"}]},{"@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\/6486","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=6486"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6486\/revisions"}],"predecessor-version":[{"id":29498,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6486\/revisions\/29498"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}