{"id":6345,"date":"2015-12-31T01:59:23","date_gmt":"2015-12-31T00:59:23","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=6345"},"modified":"2016-01-01T18:02:49","modified_gmt":"2016-01-01T17:02:49","slug":"excel-vba-calculer-le-dernier-jour-dun-mois","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=6345","title":{"rendered":"EXCEL, VBA : calculer le dernier jour d&#8217;un mois"},"content":{"rendered":"<p style=\"text-align: justify;\">Chaque mois de l&#8217;ann\u00e9e compte un nombre de jours diff\u00e9rent (31, 30, 28 ou encore 29 jours pour le mois de f\u00e9vrier les ann\u00e9es bisextiles) ce qui ne facilite pas les calculs sur des dates, par exemple pour d\u00e9terminer une date d&#8217;\u00e9ch\u00e9ance (30 jours fin de mois&#8230;).<\/p>\n<p style=\"text-align: justify;\">La fonction FIN.MOIS(date_d\u00e9part;mois) r\u00e9sout cette difficult\u00e9 en\u00a0retournant le num\u00e9ro de s\u00e9rie du dernier jour du mois pr\u00e9c\u00e9dant ou suivant <em>date_d\u00e9part<\/em> du nombre de <em>mois<\/em> indiqu\u00e9.<\/p>\n<p style=\"text-align: justify;\">Son homologue VBA est la fonction EOMONTH (pour <em>End Of MONTH<\/em>) ;\u00a0son param\u00e9trage est le m\u00eame que\u00a0FIN.MOIS\u00a0: EOMONTH(date_d\u00e9part,mois).<\/p>\n<p>Exemples :<\/p>\n<ul>\n<li>FIN.MOIS(&#8220;15\/12\/2015&#8221;;0) : 31\/12\/2015,<\/li>\n<li>FIN.MOIS(&#8220;15\/12\/2015&#8221;;1) : 31\/01\/2016 (soit fin de mois, un mois apr\u00e8s le 15 d\u00e9cembre),<\/li>\n<li style=\"text-align: justify;\">FIN.MOIS(&#8220;15\/12\/2015&#8221;;-1) : 30\/11\/2015,<\/li>\n<li style=\"text-align: justify;\">FIN.MOIS(AUJOURDHUI();0) : fin du mois en cours.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a title=\"Programmer en VBA\" href=\"http:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a> \/ <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%2C%20VBA%20%3A%20calculer%20le%20dernier%20jour%20d%27un%20mois\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Chaque mois de l&#8217;ann\u00e9e compte un nombre de jours diff\u00e9rent (31, 30, 28 ou encore 29 jours pour le mois de f\u00e9vrier les ann\u00e9es bisextiles) ce qui ne facilite pas les calculs sur des dates, par exemple pour d\u00e9terminer une date d&#8217;\u00e9ch\u00e9ance (30 jours fin de mois&#8230;). La fonction FIN.MOIS(date_d\u00e9part;mois) r\u00e9sout cette difficult\u00e9 en\u00a0retournant le &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=6345\" class=\"more-link\">Continue reading &lsquo;EXCEL, VBA : calculer le dernier jour d&#8217;un mois&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%2C%20VBA%20%3A%20calculer%20le%20dernier%20jour%20d%27un%20mois\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[7,48,1326,1569,215],"tags":[1657,1658,839,249,1541,1659,836,1656,1633,1655,263,1641],"class_list":["post-6345","post","type-post","status-publish","format-standard","hentry","category-breves","category-excel","category-maitriser-excel","category-programmer-en-vba","category-vba","tag-30-jours-fin-de-mois","tag-aujourdhui","tag-calculs","tag-cells","tag-date","tag-echeance","tag-echeancier-demprunt","tag-eomonth","tag-excel","tag-fin-mois","tag-range","tag-vba"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6345"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6345\/revisions"}],"predecessor-version":[{"id":6369,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6345\/revisions\/6369"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}