{"id":1789,"date":"2023-11-05T01:15:47","date_gmt":"2023-11-05T01:15:47","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/"},"modified":"2023-12-06T05:53:37","modified_gmt":"2023-12-06T05:53:37","slug":"willekeurige-datumgenerator","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/","title":{"rendered":"Willekeurige datumgenerator in excel"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-91261967\"><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>In deze zelfstudie leren we een eenvoudige manier om willekeurige datums tussen twee datums te genereren (startdatum en einddatum). Hiervoor heb je twee verschillende functies nodig die je in verschillende situaties kunt gebruiken.<\/p><ul><li> ALENTENTENTE<\/li><li> RANDARRAY<\/li><\/ul><h2 class=\"wp-block-heading\"> Genereer willekeurige datums met RANDBETWEEN<\/h2><p> In Excel hebben we een functie met de naam RANDBETWEEN, die een beginwaarde en een eindwaarde nodig heeft om willekeurige waarden daartussen te genereren, en u kunt deze functie gebruiken om willekeurige datums te genereren.<\/p><ol type=\"1\"><li> Geef eerst een startdatum op vanaf welke u uw willekeurige datums wilt laten beginnen.<\/li><li> Geef vervolgens een einddatum op om een bovengrens voor willekeurige datums te hebben.<\/li><li> Voer daarna de functie &#8220;RANDBETWEEN&#8221; in een cel in.<\/li><li> Raadpleeg nu de cellen waar u de begin- en einddatum in de argumenten hebt staan.<\/li><li> Vanaf daar drukt u op Enter om een enkele willekeurige datum in de cel te krijgen.<\/li><li> Onderzoek aan het einde deze cel naar de cel waar u de willekeurige datums wilt hebben. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66816\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"randbetween-voor-willekeurige-data\" width=\"505\" height=\"330\"><\/figure><\/div><p> willekeurige_datum_generator.xlsx<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RANDBETWEEN($A$2,$B$2)<\/code><\/pre><p> In de bovenstaande formule hebben we de functie RANDBETWEEN gebruikt met een startdatum en een einddatum. Zoals u kunt zien, hebben we de celverwijzing naar de cellen A2 en B2 bevroren met behulp van het dollarteken ($). En daarna moeten we de formule doorwerken naar cel C11 om de 10 willekeurige datums te krijgen.<\/p><h2 class=\"wp-block-heading\"> RANDARRAY gebruiken voor willekeurige datums<\/h2><p> Er is nog een functie die je kunt gebruiken om willekeurige getallen te genereren en dat is RANDARRAY. Deze functie heeft ook een startdatum en een einddatum.<\/p><p> Wanneer u RANDARRAY gebruikt, moet u het aantal datums opgeven dat u wilt genereren. En dit moet je specificeren in termen van kolommen en rijen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66817\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-aleatoires-pour-des-dates-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"willekeurig-voor-willekeurige-data\" width=\"542\" height=\"323\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RANDARRAY(10,2,A2,B2)<\/code><\/pre><p> In de bovenstaande formule heb ik 10 rijen en 2 kolommen gespecificeerd en het genereerde 20 willekeurige datums (10 x 2) in het resultaat.<\/p><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> beide functies die we hierboven hebben gebruikt, zijn vluchtig, wat betekent dat als u uw werkbladberekeningen herberekent, alle datums opnieuw worden gegenereerd. <\/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\/Excel-generateur-de-dates-aleatoires.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\/datumbereik\/\">Maak een datumbereik in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/aangepaste-datumformaten\/\">Aangepaste datumformaten in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datum-als\/\">DATEDIF-functie in Excel<\/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-1789","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>Willekeurige datumgenerator in Excel - Excel Advisor<\/title>\n<meta name=\"description\" content=\"In deze tutorial leert u verschillende eenvoudig te gebruiken formules om een willekeurige datumgenerator in Excel te maken.\" \/>\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\/willekeurige-datumgenerator\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Willekeurige datumgenerator in Excel - Excel Advisor\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leert u verschillende eenvoudig te gebruiken formules om een willekeurige datumgenerator in Excel te maken.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:53:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.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\/willekeurige-datumgenerator\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/\",\"name\":\"Willekeurige datumgenerator in Excel - Excel Advisor\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\",\"datePublished\":\"2023-11-05T01:15:47+00:00\",\"dateModified\":\"2023-12-06T05:53:37+00:00\",\"description\":\"In deze tutorial leert u verschillende eenvoudig te gebruiken formules om een willekeurige datumgenerator in Excel te maken.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Willekeurige datumgenerator 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":"Willekeurige datumgenerator in Excel - Excel Advisor","description":"In deze tutorial leert u verschillende eenvoudig te gebruiken formules om een willekeurige datumgenerator in Excel te maken.","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\/willekeurige-datumgenerator\/","og_locale":"nl_NL","og_type":"article","og_title":"Willekeurige datumgenerator in Excel - Excel Advisor","og_description":"In deze tutorial leert u verschillende eenvoudig te gebruiken formules om een willekeurige datumgenerator in Excel te maken.","og_url":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:53:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.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\/willekeurige-datumgenerator\/","url":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/","name":"Willekeurige datumgenerator in Excel - Excel Advisor","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png","datePublished":"2023-11-05T01:15:47+00:00","dateModified":"2023-12-06T05:53:37+00:00","description":"In deze tutorial leert u verschillende eenvoudig te gebruiken formules om een willekeurige datumgenerator in Excel te maken.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-datumgenerator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Willekeurige datumgenerator 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\/1789","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=1789"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1789\/revisions"}],"predecessor-version":[{"id":2989,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1789\/revisions\/2989"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}