{"id":571,"date":"2014-08-06T11:56:39","date_gmt":"2014-08-06T09:56:39","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=571"},"modified":"2022-11-03T15:51:05","modified_gmt":"2022-11-03T14:51:05","slug":"excel-planifier-un-projet","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/08\/excel-planifier-un-projet\/","title":{"rendered":"Excel &#8211; Planifier un projet"},"content":{"rendered":"<div class=\"entry-content\">\n<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous planifiez un projet dans Excel et avez pr\u00e9vu plusieurs colonnes pour les dates li\u00e9es aux t\u00e2ches du projet (date de d\u00e9but de la t\u00e2che, date de fin de la t\u00e2che et date de suivi). \u00c9tant donn\u00e9 que les t\u00e2ches ne sont pas toutes termin\u00e9es (certaines cellules \u00ab\u00a0date de fin\u00a0\u00bb sont vides), vous souhaitez pouvoir calculer la diff\u00e9rence entre la date de d\u00e9but et la date de suivi mais seulement en l&rsquo;absence d&rsquo;une date de fin. Vous avez pr\u00e9vu d&rsquo;entrer les dates manuellement; seule la diff\u00e9rence entre les dates doit \u00eatre calcul\u00e9e.<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<p>Utilisez la fonction* DATEDIF, sachant que dans mon exemple :<\/p>\n<\/div>\n<div class=\"entry-content\">\n<ul>\n<li>Le nom de la t\u00e2che est en A2<\/li>\n<li>La date de d\u00e9but de la t\u00e2che est en B2<\/li>\n<li>La date de fin (s&rsquo;il y en a une) est en C2<\/li>\n<li>La date de suivi pr\u00e9vue est en D2<\/li>\n<li>La formule de calcul se trouve en E2<br \/>\n=SI(C2=\u201c\u201c;DATEDIF(B2;D2;\u201cd\u201c);DATEDIF(B2;C2;\u201cd\u201c)) &amp;\u201c jours\u201c<\/li>\n<\/ul>\n<p>Autrement dit : Si la cellule C2 est vide, Excel doit calculer la diff\u00e9rence entre B2 et D2. Cette diff\u00e9rence doit \u00eatre exprim\u00e9e en jours (argument \u201cd\u201d). Si C2 n&rsquo;est pas vide, Excel doit calculer la diff\u00e9rence entre B2 et C2. Cette diff\u00e9rence doit \u00e9galement \u00eatre exprim\u00e9e en jours. L&rsquo;indication \u201c&amp; jours\u201c \u00e0 la fin de la formule fera appara\u00eetre le mot \u00ab\u00a0jours\u00a0\u00bb dans le r\u00e9sultat du calcul afin d&rsquo;\u00e9viter une mauvaise interpr\u00e9tation du r\u00e9sultat :<a href=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/DateDifetSI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-574\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/DateDifetSI-1024x223.png\" alt=\"DateDifetSI\" width=\"625\" height=\"136\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/DateDifetSI-1024x223.png 1024w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/DateDifetSI-300x65.png 300w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/DateDifetSI-624x136.png 624w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/DateDifetSI.png 1200w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>* La particularit\u00e9 de cette fonction est qu\u2019elle ne figure pas dans la liste officielle des fonctions d\u2019Excel <img decoding=\"async\" class=\"wp-smiley\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/wp-includes\/images\/smilies\/icon_wink.gif\" alt=\";)\" \/><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous planifiez un projet dans Excel et avez pr\u00e9vu plusieurs colonnes pour les dates li\u00e9es aux t\u00e2ches du projet (date de d\u00e9but de la t\u00e2che, date de&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],"tags":[53,43],"class_list":{"0":"post-571","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-date","9":"tag-fonction"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/571","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=571"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"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=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}