{"id":3184,"date":"2023-11-11T11:20:49","date_gmt":"2023-11-11T11:20:49","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/countdown-tage\/"},"modified":"2023-12-03T11:12:08","modified_gmt":"2023-12-03T11:12:08","slug":"countdown-tage","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/countdown-tage\/","title":{"rendered":"Countdown-tage in excel"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-204761144\"><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>Um eine Countdown-Formel in Excel zu schreiben, m\u00fcssen Sie ein Datum angeben, f\u00fcr das Sie den Countdown erstellen m\u00f6chten. Dar\u00fcber hinaus m\u00fcssen Sie die HEUTE-Funktion verwenden. Wenn Sie das zuk\u00fcnftige Datum vom heutigen Datum subtrahieren, werden die verbleibenden Tage zur\u00fcckgegeben. Da Sie TODAY verwenden, ist die Variable volatil und aktualisiert das Datum jeden Tag. Es erstellt einen Countdown f\u00fcr die verbleibenden Tage. <\/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=\"Countdown\" width=\"596\" height=\"217\"><\/figure><\/div><p> In diesem Tutorial lernen wir, wie man diese Formel schreibt.<\/p><h2 class=\"wp-block-heading\"> Excel-Formel zum Berechnen des Countdowns der verbleibenden Tage<\/h2><p> Sie k\u00f6nnen die folgenden Schritte ausf\u00fchren:<\/p><ol type=\"1\"><li> Geben Sie zun\u00e4chst (=) gleich in eine Zelle ein, um die Formel zu starten.<\/li><li> Schauen Sie sich danach die Zelle an, in der Sie das Datum haben.<\/li><li> Geben Sie als N\u00e4chstes das (-)-Zeichen f\u00fcr die Subtraktion ein.<\/li><li> Geben Sie nun die TODAY-Funktion ohne Argumente ein.<\/li><li> Dr\u00fccken Sie am Ende die Eingabetaste, um das Ergebnis zu erhalten. <\/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=\"Erhalten Sie einen Countdown der verbleibenden Tage\" width=\"535\" height=\"234\"><\/figure><\/div><p> Sobald Sie die Eingabetaste dr\u00fccken, wird die Anzahl der verbleibenden Tage ab dem von Ihnen angegebenen zuk\u00fcnftigen Datum zur\u00fcckgegeben. <\/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=\"gab die Anzahl der Tage zur\u00fcck\" width=\"580\" height=\"258\"><\/figure><\/div><p> In diesem Beispiel ist das Datum der 10. Februar 2023 und das von TODAY zur\u00fcckgegebene Datum ist der 18. Januar 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=\"R\u00fcckflugdatum\" width=\"469\" height=\"224\"><\/figure><\/div><p> Und wenn Sie es vom zuk\u00fcnftigen Datum abziehen, erhalten Sie die verbleibenden Tage.<\/p><p> Wie ich bereits erw\u00e4hnt habe, ist TODAY eine fl\u00fcchtige Funktion. Wenn sich das Datum in Ihrem System \u00e4ndert, \u00e4ndert sich auch das von ihr zur\u00fcckgegebene Datum, sodass es sich um einen Countdown handelt.<\/p><p> Um das Formelergebnis aussagekr\u00e4ftiger zu gestalten, k\u00f6nnen Sie es mit dem Testwert kombinieren. <\/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=\"Formel mit Textwert kombinieren\" 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\"> Holen Sie sich die Excel-Datei<\/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\">Herunterladen<\/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\/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\/fugen-sie-das-wochendatum-hinzu\/\">Addiere\/subtrahiere eine Woche von einem Datum in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/holen-sie-sich-den-namen-des-tages\/\">Erhalten Sie den Tagesnamen aus einem Datum in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/tage-des-monats\/\">Ermitteln Sie die Gesamtzahl der Tage oder Monate in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/monate-arbeitstage\/\">Arbeitstage im Monat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/datum-zu-text-2\/\">Datum in Text umwandeln<\/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-3184","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>Countdown-Tage in Excel<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln schreiben, um einen dynamischen Countdown der verbleibenden Tage ab einem Datum zu erstellen.\" \/>\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\/countdown-tage\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Countdown-Tage in Excel\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln schreiben, um einen dynamischen Countdown der verbleibenden Tage ab einem Datum zu erstellen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/countdown-tage\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:12:08+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=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/countdown-tage\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/countdown-tage\/\",\"name\":\"Countdown-Tage in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/countdown-tage\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/countdown-tage\/#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-03T11:12:08+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln schreiben, um einen dynamischen Countdown der verbleibenden Tage ab einem Datum zu erstellen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/countdown-tage\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/countdown-tage\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/countdown-tage\/#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\/de\/countdown-tage\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Countdown-tage in excel\"}]},{\"@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":"Countdown-Tage in Excel","description":"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln schreiben, um einen dynamischen Countdown der verbleibenden Tage ab einem Datum zu erstellen.","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\/countdown-tage\/","og_locale":"de_DE","og_type":"article","og_title":"Countdown-Tage in Excel","og_description":"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln schreiben, um einen dynamischen Countdown der verbleibenden Tage ab einem Datum zu erstellen.","og_url":"https:\/\/exceladvisor.org\/de\/countdown-tage\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:12:08+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":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/countdown-tage\/","url":"https:\/\/exceladvisor.org\/de\/countdown-tage\/","name":"Countdown-Tage in Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/countdown-tage\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/countdown-tage\/#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-03T11:12:08+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln schreiben, um einen dynamischen Countdown der verbleibenden Tage ab einem Datum zu erstellen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/countdown-tage\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/countdown-tage\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/countdown-tage\/#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\/de\/countdown-tage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Countdown-tage in excel"}]},{"@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\/3184","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=3184"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3184\/revisions"}],"predecessor-version":[{"id":3733,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3184\/revisions\/3733"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}