{"id":3195,"date":"2023-11-10T17:26:12","date_gmt":"2023-11-10T17:26:12","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/"},"modified":"2023-12-03T11:20:12","modified_gmt":"2023-12-03T11:20:12","slug":"suchtermine-v","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/","title":{"rendered":"Wie finde ich ein datum aus daten?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2658999559\"><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>Sie k\u00f6nnen SVERWEIS auch verwenden, um ein Datum aus \u201eDatum\u201c nachzuschlagen und dann einen Wert aus derselben Zeile in der entsprechenden Spalte abzurufen. Dazu m\u00fcssen Sie in VLOOKUP ein Datum angeben, oder Sie k\u00f6nnen es auch direkt darin angeben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79555\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup-for-a-date\" width=\"625\" height=\"401\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Verwenden von SVERWEIS mit Datumsangaben<\/h2><p> Sie k\u00f6nnen die folgenden Schritte ausf\u00fchren:<\/p><ol type=\"1\"><li> Geben Sie zun\u00e4chst die SVERWEIS-Funktion in eine Zelle ein.<\/li><li> Beziehen Sie sich anschlie\u00dfend im ersten Argument auf Zelle D2, in der Sie das Datum finden, nach dem gesucht werden soll.<\/li><li> Geben Sie nun im zweiten Argument den Bereich A1:B13 an.<\/li><li> Geben Sie dann im dritten Argument 2 ein, da Sie die Werte aus der zweiten Spalte erhalten m\u00f6chten.<\/li><li> Geben Sie am Ende im vierten Argument 0 ein, um das exakte Argument auszuf\u00fchren. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79556\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-vlookup-avec-des-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-vlookup-with-dates\" width=\"713\" height=\"384\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=VLOOKUP(VALUE(D2),A1:B13,2,0)<\/code><\/pre><h2 class=\"wp-block-heading\"> Geben Sie das Datum direkt in VLOOKUP ein<\/h2><p> Sie k\u00f6nnen ein Datum auch direkt in die Funktion einf\u00fcgen. Siehe das Beispiel unten: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=VLOOKUP(DATEVALUE(\"02-Dec-2022\"),A1:B13,2,0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79557\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrer-la-date-dans-la-fonction-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"Enter-date-in-vlookup-function\" width=\"697\" height=\"410\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Zu beachtende Punkte<\/h2><ol type=\"1\"><li> Excel speichert das Datum als Zahl, und das gesuchte Datum sowie die Daten in den Daten m\u00fcssen gem\u00e4\u00df dem Datums- und Zeitcode von Excel g\u00fcltig sein.<\/li><li> Wenn Sie ein Datum in die Funktion einf\u00fcgen m\u00f6chten, m\u00fcssen Sie die Funktion DATEVALUE verwenden, um das eingef\u00fcgte Datum in ein g\u00fcltiges Excel-Datum umzuwandeln. <\/li><\/ol><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/date-de-recherche-v.xlsx\" rel=\"nofollow\">Herunterladen<\/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\/de\/formeln\/\">Liste der Excel-Formeln<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Verwandte Formeln <\/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\/de\/iferror-vlookup\/\">IFERROR mit VLOOKUP in Excel, um #N\/A in Excel zu ersetzen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/bidirektionale-suche\/\">F\u00fchren Sie eine bidirektionale Suche in Excel durch<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ruckwartssuche\/\">Reverse SVERWEIS (r\u00fcckw\u00e4rts: von rechts nach links) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/vsearch-ubereinstimmung\/\">Kombinieren von VLOOKUP MATCH in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/suchen-sie-nach-mehreren-kriterien\/\">SVERWEIS mit mehreren Kriterien in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/platzhalter-mit-vlookup\/\">Platzhalter mit VLOOKUP 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-3195","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>[SVERWEIS] Wie finde ich ein Datum aus Daten?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial lernen wir, wie man in VLOOKUP eine Formel f\u00fcr ein Datum aus Daten in Excel schreibt. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\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\/de\/suchtermine-v\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[SVERWEIS] Wie finde ich ein Datum aus Daten?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial lernen wir, wie man in VLOOKUP eine Formel f\u00fcr ein Datum aus Daten in Excel schreibt. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:20:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/\",\"name\":\"[SVERWEIS] Wie finde ich ein Datum aus Daten?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\",\"datePublished\":\"2023-11-10T17:26:12+00:00\",\"dateModified\":\"2023-12-03T11:20:12+00:00\",\"description\":\"In diesem Tutorial lernen wir, wie man in VLOOKUP eine Formel f\u00fcr ein Datum aus Daten in Excel schreibt. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie finde ich ein datum aus daten?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[SVERWEIS] Wie finde ich ein Datum aus Daten?","description":"In diesem Tutorial lernen wir, wie man in VLOOKUP eine Formel f\u00fcr ein Datum aus Daten in Excel schreibt. Lassen Sie uns das \u00fcberpr\u00fcfen ...","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\/de\/suchtermine-v\/","og_locale":"de_DE","og_type":"article","og_title":"[SVERWEIS] Wie finde ich ein Datum aus Daten?","og_description":"In diesem Tutorial lernen wir, wie man in VLOOKUP eine Formel f\u00fcr ein Datum aus Daten in Excel schreibt. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:20:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/","url":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/","name":"[SVERWEIS] Wie finde ich ein Datum aus Daten?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png","datePublished":"2023-11-10T17:26:12+00:00","dateModified":"2023-12-03T11:20:12+00:00","description":"In diesem Tutorial lernen wir, wie man in VLOOKUP eine Formel f\u00fcr ein Datum aus Daten in Excel schreibt. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/suchtermine-v\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/suchtermine-v\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie finde ich ein datum aus daten?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3195"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3195\/revisions"}],"predecessor-version":[{"id":3992,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3195\/revisions\/3992"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}