{"id":1693,"date":"2023-11-11T11:20:49","date_gmt":"2023-11-11T11:20:49","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/"},"modified":"2023-12-06T05:55:26","modified_gmt":"2023-12-06T05:55:26","slug":"dagen-aftellen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/","title":{"rendered":"Dagen aftellen in excel"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3687889287\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Als u een aftelformule in Excel wilt schrijven, moet u een datum opgeven waarvoor u het aftellen wilt maken. Daarnaast moet u de TODAY-functie gebruiken. Wanneer u de datum in de toekomst aftrekt van de datum van vandaag, worden de resterende dagen geretourneerd. Omdat u TODAY gebruikt, dat vluchtig is en de datum elke dag bijwerkt. Er wordt een aftelling voor de resterende dagen gemaakt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80160\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\" sizes=\"auto, \" srcset=\"\" alt=\"aftellen\" width=\"596\" height=\"217\"><\/figure><\/div><p> In deze tutorial leren we hoe we deze formule kunnen schrijven.<\/p><h2 class=\"wp-block-heading\"> Excel-formule om het aftellen van de resterende dagen te krijgen<\/h2><p> U kunt de onderstaande stappen gebruiken:<\/p><ol type=\"1\"><li> Voer eerst (=) is gelijk in een cel in om de formule te starten.<\/li><li> Raadpleeg daarna de cel waar u de datum hebt.<\/li><li> Voer vervolgens het teken (-) in voor aftrekken.<\/li><li> Voer nu de TODAY-functie in zonder argumenten.<\/li><li> Druk aan het einde op Enter om het resultaat te krijgen. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80161\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-le-compte-a-rebours-des-jours-restants.png\" sizes=\"auto, \" srcset=\"\" alt=\"krijg het aftellen van de resterende dagen\" width=\"535\" height=\"234\"><\/figure><\/div><p> Zodra u op Enter drukt, wordt het resterende aantal dagen geretourneerd vanaf de toekomstige datum die u hebt opgegeven. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-TODAY()<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80162\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-a-renvoye-le-nombre-de-jours.png\" sizes=\"auto, \" srcset=\"\" alt=\"gaf het aantal dagen terug\" width=\"580\" height=\"258\"><\/figure><\/div><p> In dit voorbeeld is de datum 10 februari 2023 en de datum die TODAY retourneert is 18 januari 2023. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80163\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-date-de-retour.png\" sizes=\"auto, \" srcset=\"\" alt=\"retourdatum\" width=\"469\" height=\"224\"><\/figure><\/div><p> En als u het van de toekomstige datum aftrekt, krijgt u de resterende dagen.<\/p><p> Zoals ik eerder al zei, is TODAY een vluchtige functie, en wanneer de datum in uw systeem verandert, verandert deze ook de datum die erdoor wordt geretourneerd, waardoor het een aftelling wordt.<\/p><p> Om het formuleresultaat betekenisvoller te maken, kunt u het combineren met de testwaarde. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80164\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-combiner-la-formule-avec-la-valeur-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"combineer-formule-met-tekstwaarde\" width=\"612\" height=\"232\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-TODAY()&amp;\" day(s) remaning.\"<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Haal het Excel-bestand op<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours.xlsx\" rel=\"nofollow\">Downloaden<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-de-datum-van-de-week-toe\/\">Week optellen en aftrekken van een datum in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/krijg-de-naam-van-de-dag\/\">Haal de dagnaam op uit een datum in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/dagen-van-de-maand\/\">Krijg het totale aantal dagen van maanden in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/maanden-werkdagen\/\">Werkdagen in een maand<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datum-tot-tekst-2\/\">Converteer datum naar tekst<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1693","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Dagen aftellen in Excel<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u Excel-formules schrijft om dynamisch af te tellen van de resterende dagen vanaf een datum.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dagen aftellen in Excel\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u Excel-formules schrijft om dynamisch af te tellen van de resterende dagen vanaf een datum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:55:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/\",\"name\":\"Dagen aftellen in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\",\"datePublished\":\"2023-11-11T11:20:49+00:00\",\"dateModified\":\"2023-12-06T05:55:26+00:00\",\"description\":\"In deze zelfstudie leert u hoe u Excel-formules schrijft om dynamisch af te tellen van de resterende dagen vanaf een datum.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dagen aftellen in excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dagen aftellen in Excel","description":"In deze zelfstudie leert u hoe u Excel-formules schrijft om dynamisch af te tellen van de resterende dagen vanaf een datum.","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:\/\/exceladvisor.org\/nl\/dagen-aftellen\/","og_locale":"nl_NL","og_type":"article","og_title":"Dagen aftellen in Excel","og_description":"In deze zelfstudie leert u hoe u Excel-formules schrijft om dynamisch af te tellen van de resterende dagen vanaf een datum.","og_url":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:55:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/","url":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/","name":"Dagen aftellen in Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","datePublished":"2023-11-11T11:20:49+00:00","dateModified":"2023-12-06T05:55:26+00:00","description":"In deze zelfstudie leert u hoe u Excel-formules schrijft om dynamisch af te tellen van de resterende dagen vanaf een datum.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/dagen-aftellen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Dagen aftellen in excel"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1693"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1693\/revisions"}],"predecessor-version":[{"id":2990,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1693\/revisions\/2990"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}