{"id":1580,"date":"2023-11-16T09:57:07","date_gmt":"2023-11-16T09:57:07","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/datumbereik\/"},"modified":"2023-12-06T05:50:00","modified_gmt":"2023-12-06T05:50:00","slug":"datumbereik","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/datumbereik\/","title":{"rendered":"Hoe maak je een datumbereik in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3181228283\"><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>Wanneer u werkt met gegevens die datums bevatten, moet u mogelijk een datumbereik maken. Een bereik is iets dat een begindatum en een einddatum heeft. In deze zelfstudie leert u hoe u een datumbereik maakt.<\/p><h2 class=\"wp-block-heading\"> Maak een datumbereik vanaf vandaag<\/h2><p> Stel nu dat u zeven dagen vanaf vandaag een datumbereik wilt maken. In het volgende voorbeeld hebben we de datum van vandaag in cel A1 die we hebben verkregen met behulp van de functie vandaag. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64220\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"datumbereik-vanaf-vandaag\" width=\"387\" height=\"284\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+7<\/code><\/pre><p> Volg deze eenvoudige stappen om een datumbereik te maken:<\/p><ol type=\"1\"><li> Voer de \u201c=\u201d in cel B1 of een andere cel in.<\/li><li> Raadpleeg cel A1, waar u de begindatum van het bereik vindt.<\/li><li> Gebruik het teken &#8220;+&#8221; om dagen toe te voegen aan de datum van vandaag.<\/li><li> Geef het aantal dagen op dat u aan de datum van vandaag wilt toevoegen. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64221\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-creer-une-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"maak-een-datumbereik\" width=\"395\" height=\"239\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Maak een datumbereik in \u00e9\u00e9n cel<\/h2><p> Laten we nog een stap verder gaan en een datumbereik in \u00e9\u00e9n cel maken. En hiervoor moeten we zowel de startdatum als de einddatum in \u00e9\u00e9n cel combineren. Maar het probleem is dat wanneer u twee datums in \u00e9\u00e9n cel probeert te combineren, het resultaat zoiets als hieronder oplevert. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64222\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-creer-une-plage-de-dates-dans-une-seule-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"maak-een-datumbereik-in-\u00e9\u00e9n-cel\" width=\"452\" height=\"242\"><\/figure><\/div><p> Om dit probleem op te lossen, moeten we de functie TEXT gebruiken om de datums naar tekst te converteren en ze vervolgens in een datumbereik te combineren. De formule zou ongeveer zoals hieronder zijn. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64224\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-de-texte-pour-la-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"tekstfunctie voor datumbereik\" width=\"626\" height=\"268\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"dd\/mmm\/yy\")&amp;\" --- \"&amp;TEXT(B1,\"dd\/mmm\/yy\")<\/code><\/pre><p> Zoals u kunt zien, hebben we een datumbereik in cel C1 van 8, 22 februari tot 15, 22 februari. En als u een datumbereik in \u00e9\u00e9n cel wilt maken, kunt u de volgende formule gebruiken.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(TODAY(),\"dd\/mmm\/yy\")&amp;\" --- \"&amp;TEXT(A1+7,\"dd\/mmm\/yy\")<\/code><\/pre><p> In het gedeelte over het gebruik van de TEKST-functie kunt u het datumformaat naar wens wijzigen. <\/p><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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates.xlsx\" rel=\"nofollow\">Downloaden<\/a><\/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\/vergelijk-twee-data\/\">Vergelijk twee datums in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/converteer-datum-naar-getal\/\">Converteer datum naar getal in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tekst-tot-nu-toe\/\">Converteer tekst naar datum in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/aangepaste-datumformaten\/\">Aangepaste datumformaten in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tussen-twee-datums-markeren\/\">Markeer datums tussen twee datums in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/twee-data-aan-elkaar-koppelen\/\">Voeg snel twee datums samen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/\">Willekeurige datumgenerator (Excel-formule) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/combineer-datum-en-tijd\/\">Combineer datum en tijd in Excel<\/a><\/li><\/ul><\/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-1580","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>Hoe maak je een datumbereik in Excel? - Excel-adviseur<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie over formules leert u hoe u een datumbereik maakt met behulp van de tekstfunctie en de\" \/>\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\/datumbereik\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe maak je een datumbereik in Excel? - Excel-adviseur\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie over formules leert u hoe u een datumbereik maakt met behulp van de tekstfunctie en de\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/datumbereik\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.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=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/\",\"name\":\"Hoe maak je een datumbereik in Excel? - Excel-adviseur\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\",\"datePublished\":\"2023-11-16T09:57:07+00:00\",\"dateModified\":\"2023-12-06T05:50:00+00:00\",\"description\":\"In deze zelfstudie over formules leert u hoe u een datumbereik maakt met behulp van de tekstfunctie en de\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/datumbereik\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/datumbereik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe maak je een datumbereik 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":"Hoe maak je een datumbereik in Excel? - Excel-adviseur","description":"In deze zelfstudie over formules leert u hoe u een datumbereik maakt met behulp van de tekstfunctie en de","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\/datumbereik\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe maak je een datumbereik in Excel? - Excel-adviseur","og_description":"In deze zelfstudie over formules leert u hoe u een datumbereik maakt met behulp van de tekstfunctie en de","og_url":"https:\/\/exceladvisor.org\/nl\/datumbereik\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/datumbereik\/","url":"https:\/\/exceladvisor.org\/nl\/datumbereik\/","name":"Hoe maak je een datumbereik in Excel? - Excel-adviseur","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/datumbereik\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/datumbereik\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","datePublished":"2023-11-16T09:57:07+00:00","dateModified":"2023-12-06T05:50:00+00:00","description":"In deze zelfstudie over formules leert u hoe u een datumbereik maakt met behulp van de tekstfunctie en de","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/datumbereik\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/datumbereik\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/datumbereik\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/datumbereik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe maak je een datumbereik 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\/1580","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=1580"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1580\/revisions"}],"predecessor-version":[{"id":2665,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1580\/revisions\/2665"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}