{"id":6852,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fraction-annee\/"},"modified":"2021-02-26T08:16:36","modified_gmt":"2021-02-26T08:16:36","slug":"yearfrac","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/yearfrac\/","title":{"rendered":"FRACTION.ANNEE"},"content":{"rendered":"

Dans cet article, nous allons explorer la fonction FRACTION.ANNEE<\/strong> (ou YEARFRAC<\/strong> en anglais), utilis\u00e9e dans Microsoft Excel et Google Sheets. Cette fonction est extr\u00eamement utile pour d\u00e9terminer la fraction d’une ann\u00e9e repr\u00e9sent\u00e9e par l’intervalle de jours entre deux dates donn\u00e9es.<\/p>\n

Pr\u00e9sentation de la syntaxe et des param\u00e8tres<\/h2>\n

La syntaxe de la fonction FRACTION.ANNEE est la suivante :<\/p>\n

=FRACTION.ANNEE(date_d\u00e9but, date_fin, [base])<\/code><\/pre>\n
    \n
  • date_d\u00e9but<\/strong> : Correspond \u00e0 la date initiale de la p\u00e9riode \u00e9tudi\u00e9e. Cette date doit \u00eatre valide dans Excel ou Google Sheets.<\/li>\n
  • date_fin<\/strong> : Repr\u00e9sente la date de cl\u00f4ture de la p\u00e9riode. Elle doit \u00e9galement \u00eatre une date valide et doit se situer apr\u00e8s la date de d\u00e9but.<\/li>\n
  • base<\/strong> (optionnel) : Ce param\u00e8tre est un nombre qui sp\u00e9cifie la convention de comptage des jours \u00e0 utiliser pour le calcul :\n
      \n
    • 0 ou omis<\/strong> : Utilise la convention 30\/360 US (NASD)<\/li>\n
    • 1<\/strong> : Adopte la convention r\u00e9elle\/365 (m\u00e9thode classique utilis\u00e9e en fran\u00e7ais)<\/li>\n
    • 2<\/strong> : S’appuie sur la convention r\u00e9elle\/360<\/li>\n
    • 3<\/strong> : Base r\u00e9elle\/365 (m\u00e9thode am\u00e9ricaine)<\/li>\n
    • 4<\/strong> : Base 30\/360 europ\u00e9enne<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Exemples d’utilisation<\/h2>\n
      Supposons que vous souhaitez estimer le nombre d’ann\u00e9es fractionnaires entre le 1er mai 2023 et le 1er janvier 2024. Vous pouvez proc\u00e9der comme suit avec la fonction FRACTION.ANNEE :<\/p>\n
      =FRACTION.ANNEE(\"2023-05-01\", \"2024-01-01\", 1)<\/code><\/pre>\n
      Ce calcul retournera 0.676712<\/strong>, indiquant que la p\u00e9riode repr\u00e9sente environ 67.67% d’une ann\u00e9e, selon la convention r\u00e9elle\/365.<\/p>\n
      Sc\u00e9narios d’application pratiques<\/h2>\n
      Explorons quelques situations pratiques o\u00f9 l’utilisation de cette fonction peut s’av\u00e9rer tr\u00e8s avantageuse.<\/p>\n
      Calcul des int\u00e9r\u00eats sur une p\u00e9riode partielle<\/h2>\n
      Imaginons que vous soyez un investisseur d\u00e9sirant calculer les int\u00e9r\u00eats accumul\u00e9s sur une p\u00e9riode qui ne constitue pas une ann\u00e9e compl\u00e8te. Vous avez investi 10 000 \u20ac avec un taux annuel de 5%. Voici comment vous pourriez estimer les int\u00e9r\u00eats pour une p\u00e9riode allant du 15 mars 2023 au 15 juillet 2023 :<\/p>\n
      =10000 * 0.05 * FRACTION.ANNEE(\"2023-03-15\", \"2023-07-15\", 1)<\/code><\/pre>\n
      Cette formule vous donnera les int\u00e9r\u00eats accumul\u00e9s pour cette p\u00e9riode, bas\u00e9e sur une ann\u00e9e r\u00e9elle de 365 jours.<\/p>\n
      Comparer la dur\u00e9e d’emploi<\/h2>\n
      Supposez que vous soyez un gestionnaire des ressources humaines et que vous deviez comparer la dur\u00e9e d’emploi de deux salari\u00e9s afin de calculer des primes proportionnelles \u00e0 leur anciennet\u00e9. Si un employ\u00e9 a commenc\u00e9 le 1er juillet 2019 et un autre le 15 mars 2020, vous pourriez \u00e9valuer leur dur\u00e9e de service jusqu’au 31 d\u00e9cembre 2023 de la mani\u00e8re suivante :<\/p>\n
      =FRACTION.ANNEE(\"2019-07-01\", \"2023-12-31\", 1) - FRACTION.ANNEE(\"2020-03-15\", \"2023-12-31\", 1)<\/code><\/pre>\n
      Cet exemple montre comment d\u00e9terminer la diff\u00e9rence en ann\u00e9es fractionnaires entre les dur\u00e9es de service de deux employ\u00e9s, ce qui peut \u00eatre utile pour ajuster leurs primes ou \u00e9valuer d’autres aspects bas\u00e9s sur leur anciennet\u00e9.<\/p>\n
      La fonction FRACTION.ANNEE est donc non seulement simple \u00e0 utiliser, mais offre aussi la flexibilit\u00e9 n\u00e9cessaire pour s’adapter \u00e0 divers sc\u00e9narios professionnels et personnels o\u00f9 un calcul pr\u00e9cis de la dur\u00e9e entre deux dates est requis.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la fRaction de l\u2019ann\u00e9e RepR\u00e9sentant le nombRe de jouRs entRe la date de d\u00e9but et la date de fin<\/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-6852","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction YEARFRAC (FRACTION.ANNEE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction YEARFRAC (FRACTION.ANNEE) 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\/yearfrac\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction YEARFRAC (FRACTION.ANNEE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction YEARFRAC (FRACTION.ANNEE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/yearfrac\/\" \/>\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:36+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction YEARFRAC (FRACTION.ANNEE) 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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/yearfrac\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/yearfrac\/\",\"name\":\"Fonction YEARFRAC (FRACTION.ANNEE) 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:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction YEARFRAC (FRACTION.ANNEE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/yearfrac\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/yearfrac\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/yearfrac\/#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\":\"FRACTION.ANNEE\"}]},{\"@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 YEARFRAC (FRACTION.ANNEE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction YEARFRAC (FRACTION.ANNEE) 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\/yearfrac\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction YEARFRAC (FRACTION.ANNEE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction YEARFRAC (FRACTION.ANNEE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/yearfrac\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction YEARFRAC (FRACTION.ANNEE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/yearfrac\/","url":"https:\/\/functiontranslator.com\/fr\/yearfrac\/","name":"Fonction YEARFRAC (FRACTION.ANNEE) 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:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction YEARFRAC (FRACTION.ANNEE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/yearfrac\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/yearfrac\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/yearfrac\/#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":"FRACTION.ANNEE"}]},{"@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\/6852","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=6852"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6852\/revisions"}],"predecessor-version":[{"id":29861,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6852\/revisions\/29861"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}