{"id":369,"date":"2025-07-23T11:57:00","date_gmt":"2025-07-23T09:57:00","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=369"},"modified":"2025-08-14T11:55:25","modified_gmt":"2025-08-14T09:55:25","slug":"excel-365-calculer-la-difference-entre-deux-dates","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2025\/07\/excel-365-calculer-la-difference-entre-deux-dates\/","title":{"rendered":"Excel 365 &#8211; Calculer la diff\u00e9rence entre deux dates"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong>Contexte<\/strong><\/h4>\n\n\n\n<p>Vous avez saisi dans Excel deux dates, par exemple la date d&rsquo;entr\u00e9e en service (jour.mois.ann\u00e9e) d&rsquo;un collaborateur ainsi que la date de son d\u00e9part \u00e0 la retraite (jour.mois.ann\u00e9e). Vous souhaiteriez obtenir dans une autre cellule la diff\u00e9rence entre ces deux dates. Vous avez pens\u00e9 faire une simple soustraction mais le r\u00e9sultat obtenu en jours, bien que correct, ne vous satisfait pas totalement.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Solution<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Utilisez la fonction DATEDIF sachant que :\n<ul class=\"wp-block-list\">\n<li>la date d&rsquo;entr\u00e9e en service se trouve par ex. dans la cellule C8<\/li>\n\n\n\n<li>la date de d\u00e9part \u00e0 la retraite se trouve par ex. dans la cellule D8<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Alors votre formule de calcul doit \u00eatre : =DATEDIF(C8;D8;\u00a0\u00bby\u00a0\u00bb)<\/li>\n<\/ul>\n\n\n\n<p>L&rsquo;argument \u00ab\u00a0y\u00a0\u00bb indique dans quelle unit\u00e9 doit \u00eatre calcul\u00e9e la diff\u00e9rence. Si vous saisissez \u00ab\u00a0m\u00a0\u00bb ou \u00ab\u00a0d\u00a0\u00bb \u00e0 la place du \u00ab\u00a0y\u00a0\u00bb, vous obtiendrez respectivement un r\u00e9sultat sous forme de mois ou de jours.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>La particularit\u00e9 de cette fonction tr\u00e8s pratique est qu&rsquo;elle ne figure pas dans la liste officielle des fonctions d&rsquo;Excel.<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez saisi dans Excel deux dates, par exemple la date d&rsquo;entr\u00e9e en service (jour.mois.ann\u00e9e) d&rsquo;un collaborateur ainsi que la date de son d\u00e9part \u00e0 la retraite&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4,72],"tags":[53,43],"class_list":{"0":"post-369","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"category-office","9":"tag-date","10":"tag-fonction"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=369"}],"version-history":[{"count":5,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/369\/revisions"}],"predecessor-version":[{"id":4789,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/369\/revisions\/4789"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}