{"id":6485,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-datedif\/"},"modified":"2021-02-26T08:04:18","modified_gmt":"2021-02-26T08:04:18","slug":"datedif","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/datedif\/","title":{"rendered":"DATEDIF"},"content":{"rendered":"

Introduction \u00e0 une fonction utile pour calculer les diff\u00e9rences de dates<\/h2>\n

La fonction DATEDIF est con\u00e7ue pour calculer l’\u00e9cart entre deux dates dans Microsoft Excel et Google Sheets. Elle se r\u00e9v\u00e8le particuli\u00e8rement pr\u00e9cieuse pour examiner des dur\u00e9es telles que l’\u00e2ge d’une personne \u00e0 une date pr\u00e9cise, la long\u00e9vit\u00e9 d’un contrat de travail, ou l’intervalle entre deux \u00e9v\u00e9nements marquants.<\/p>\n

Syntaxe et exemples<\/h2>\n

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

=DATEDIF(date_initiale, date_finale, \"unit\u00e9\")<\/code><\/pre>\n
Le terme \u00ab\u00a0unit\u00e9\u00a0\u00bb d\u00e9termine le format du r\u00e9sultat et peut \u00eatre exprim\u00e9 en jours, mois ou ann\u00e9es. Voici les options les plus utilis\u00e9es :<\/p>\n
    \n
  • \"Y\"<\/code> : indique le nombre total d’ann\u00e9es \u00e9coul\u00e9es entre les deux dates.<\/li>\n
  • \"M\"<\/code> : fournit le nombre total de mois \u00e9coul\u00e9s entre les deux dates.<\/li>\n
  • \"D\"<\/code> : donne le total de jours entre les deux dates.<\/li>\n
  • \"YM\"<\/code> : calcule la diff\u00e9rence en mois, apr\u00e8s avoir d\u00e9compt\u00e9 les ann\u00e9es compl\u00e8tes.<\/li>\n
  • \"YD\"<\/code> : calcule la diff\u00e9rence en jours, apr\u00e8s avoir d\u00e9compt\u00e9 les annn\u00e9es compl\u00e8tes.<\/li>\n
  • \"MD\"<\/code> : montre la diff\u00e9rence en jours, une fois les ann\u00e9es compl\u00e8tes et les mois entiers soustraits.<\/li>\n<\/ul>\n
    Exemple de calcul du nombre de jours entre deux dates :<\/p>\n
    =DATEDIF(\"2023-01-01\", \"2023-12-31\", \"D\")<\/code><\/pre>\n
    Cette formule renvoie 364<\/b>, repr\u00e9sentant le nombre de jours entre le 1er janvier 2023 et le 31 d\u00e9cembre 2023.<\/p>\n
    Cas pratiques d’utilisation<\/h2>\n
    Calcul de l’\u00e2ge d’une personne<\/h3>\n
    Pour calculer l’\u00e2ge d’une personne n\u00e9e le 10 mai 1990 \u00e0 la date du 22 d\u00e9cembre 2023, utilisez :<\/p>\n
    =DATEDIF(\"1990-05-10\", \"2023-12-22\", \"Y\")<\/code><\/pre>\n
    Cette formule indique que la personne a 33 ans \u00e0 cette date, avec un r\u00e9sultat de 33<\/b>.<\/p>\n
    D\u00e9termination de la dur\u00e9e d’un abonnement<\/h3>\n
    Consid\u00e9rant un abonnement d\u00e9but\u00e9 le 15 janvier 2021, pour savoir combien de mois se sont \u00e9coul\u00e9s jusqu’au 15 avril 2023 :<\/p>\n
    =DATEDIF(\"2021-01-15\", \"2023-04-15\", \"M\")<\/code><\/pre>\n
    Ce calcul donne un total de 27<\/b> mois, ce qui peut \u00eatre pr\u00e9cieux pour l’analyse de la fid\u00e9lit\u00e9 des clients ou la gestion des renouvellements d’abonnements.<\/p>\n
    Conclusion<\/h2>\n
    En d\u00e9finitive, la fonction DATEDIF est un outil extr\u00eamement polyvalent pour tout travail n\u00e9cessitant des calculs de p\u00e9riodes entre deux dates. Que ce soit en ressources humaines ou en gestion client\u00e8le, ma\u00eetriser cette fonction peut grandement facilit\u00e9 votre travail quotidien.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Calcule le nombre de jours, de mois ou d\u2019ann\u00e9es qui s\u00e9parent deux dates Cette fonction est utile dans les formules o\u00f9 vous devez calculer un \u00e2ge<\/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-6485","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction DATEDIF dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DATEDIF 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\/datedif\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DATEDIF dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DATEDIF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/datedif\/\" \/>\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:18+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DATEDIF 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\/datedif\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/datedif\/\",\"name\":\"Fonction DATEDIF 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:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DATEDIF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/datedif\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/datedif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/datedif\/#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\":\"DATEDIF\"}]},{\"@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 DATEDIF dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DATEDIF 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\/datedif\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DATEDIF dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DATEDIF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/datedif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DATEDIF 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\/datedif\/","url":"https:\/\/functiontranslator.com\/fr\/datedif\/","name":"Fonction DATEDIF 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:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DATEDIF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/datedif\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/datedif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/datedif\/#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":"DATEDIF"}]},{"@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\/6485","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=6485"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6485\/revisions"}],"predecessor-version":[{"id":29497,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6485\/revisions\/29497"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}