{"id":1585,"date":"2023-11-16T09:01:55","date_gmt":"2023-11-16T09:01:55","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/"},"modified":"2023-12-06T05:50:42","modified_gmt":"2023-12-06T05:50:42","slug":"vergelijk-twee-data","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/","title":{"rendered":"Hoe twee datums in excel vergelijken?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2816431937\"><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 Excel kunt u twee datums vergelijken met behulp van een snelle en eenvoudige formule die WAAR of ONWAAR in het resultaat kan retourneren. Of u kunt ook de ALS-functie gebruiken om het aangepaste bericht in het resultaat te krijgen terwijl u twee datums vergelijkt.<\/p><p> In het volgende voorbeeld hebben we twee verschillende datums in de cellen A1 en B1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64884\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"vergelijk-twee-data\" width=\"388\" height=\"274\"><\/figure><\/div><p> U kunt de volgende stappen gebruiken:<\/p><ol type=\"1\"><li> Voer eerst het gelijkteken \u201c=\u201d in cel C1 in.<\/li><li> Raadpleeg nu cel A1 waar u de eerste date heeft.<\/li><li> Voer vervolgens opnieuw het gelijkteken \u201c=\u201d in.<\/li><li> Raadpleeg daarna cel B1 waar u de tweede datum hebt.<\/li><li> Druk aan het einde op Enter. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1=B1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64885\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-comparer-les-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"formule-om-vergelijk-data\" width=\"414\" height=\"229\"><\/figure><\/div><p> Later in deze tutorial zullen we een paar verschillende voorbeelden bekijken om het te begrijpen.<\/p><h2 class=\"wp-block-heading\"> Vergelijk ALS een datum groter is dan een andere datum<\/h2><p> In het volgende voorbeeld hebben we de eerste datum met de tweede vergeleken, als de eerste datum groter is dan de tweede datum. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&gt;B1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comparer-plus-grande-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"vergelijk-grootste-datum\" width=\"424\" height=\"234\"><\/figure><\/div><p> In de formule hebben we hiervoor de operator groter dan gebruikt.<\/p><h2 class=\"wp-block-heading\"> Vergelijk een datum met de datum van vandaag<\/h2><p> Op dezelfde manier kunt u, als u een datum wilt vergelijken met de datum van vandaag, de functie VANDAAG gebruiken. In het volgende voorbeeld hebben we de functie VANDAAG gebruikt en deze vervolgens vergeleken met een andere datum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64887\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-comparer-la-date-avec-aujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"vergelijk-datum-met-vandaag\" width=\"421\" height=\"263\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A5=TODAY()<\/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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comparer-les-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\/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><\/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-1585","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>\u25b7 Hoe twee datums vergelijken in Excel? (Gids 2023)<\/title>\n<meta name=\"description\" content=\"In deze tutorial leer je de eenvoudige formule om twee datums in dezelfde cel in alle situaties te combineren...\" \/>\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\/vergelijk-twee-data\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe twee datums vergelijken in Excel? (Gids 2023)\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leer je de eenvoudige formule om twee datums in dezelfde cel in alle situaties te combineren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.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\/vergelijk-twee-data\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/\",\"name\":\"\u25b7 Hoe twee datums vergelijken in Excel? (Gids 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\",\"datePublished\":\"2023-11-16T09:01:55+00:00\",\"dateModified\":\"2023-12-06T05:50:42+00:00\",\"description\":\"In deze tutorial leer je de eenvoudige formule om twee datums in dezelfde cel in alle situaties te combineren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe twee datums in excel vergelijken?\"}]},{\"@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":"\u25b7 Hoe twee datums vergelijken in Excel? (Gids 2023)","description":"In deze tutorial leer je de eenvoudige formule om twee datums in dezelfde cel in alle situaties te combineren...","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\/vergelijk-twee-data\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe twee datums vergelijken in Excel? (Gids 2023)","og_description":"In deze tutorial leer je de eenvoudige formule om twee datums in dezelfde cel in alle situaties te combineren...","og_url":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:42+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.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\/vergelijk-twee-data\/","url":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/","name":"\u25b7 Hoe twee datums vergelijken in Excel? (Gids 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png","datePublished":"2023-11-16T09:01:55+00:00","dateModified":"2023-12-06T05:50:42+00:00","description":"In deze tutorial leer je de eenvoudige formule om twee datums in dezelfde cel in alle situaties te combineren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/vergelijk-twee-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe twee datums in excel vergelijken?"}]},{"@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\/1585","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=1585"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1585\/revisions"}],"predecessor-version":[{"id":2773,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1585\/revisions\/2773"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}