{"id":1691,"date":"2023-11-11T11:20:49","date_gmt":"2023-11-11T11:20:49","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/"},"modified":"2023-12-10T06:01:27","modified_gmt":"2023-12-10T06:01:27","slug":"geri-sayim-gunleri","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/","title":{"rendered":"Excel&#39;de geri say\u0131m g\u00fcnleri"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2117537682\"><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>Excel&#8217;de geri say\u0131m form\u00fcl\u00fc yazmak i\u00e7in geri say\u0131m\u0131 olu\u015fturmak istedi\u011finiz tarihi belirtmeniz gerekir. Bununla birlikte BUG\u00dcN \u00f6zelli\u011fini de kullanman\u0131z gerekiyor. Bug\u00fcn\u00fcn tarihinden gelecek tarihi \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda kalan g\u00fcnleri d\u00f6nd\u00fcr\u00fcr. U\u00e7ucu olan ve her g\u00fcn tarihi g\u00fcncelleyen TODAY&#8217;i kulland\u0131\u011f\u0131n\u0131z i\u00e7in. Kalan g\u00fcnler i\u00e7in bir geri say\u0131m olu\u015fturur. <\/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=\"geri say\u0131m\" width=\"596\" height=\"217\"><\/figure><\/div><p> Bu dersimizde bu form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Kalan g\u00fcnlerin geri say\u0131m\u0131n\u0131 almak i\u00e7in Excel form\u00fcl\u00fc<\/h2><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz:<\/p><ol type=\"1\"><li> \u0130lk olarak, form\u00fcl\u00fc ba\u015flatmak i\u00e7in bir h\u00fccreye (=) e\u015fittir girin.<\/li><li> Bundan sonra tarihin bulundu\u011fu h\u00fccreye bak\u0131n.<\/li><li> Daha sonra \u00e7\u0131karma i\u015flemi i\u00e7in (-) i\u015faretini girin.<\/li><li> \u015eimdi BUG\u00dcN fonksiyonuna herhangi bir arg\u00fcman olmadan girin.<\/li><li> Sonunda sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n. <\/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=\"kalan g\u00fcnlerin geri say\u0131m\u0131n\u0131 al\u0131n\" width=\"535\" height=\"234\"><\/figure><\/div><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda, belirtti\u011finiz gelecek tarihten itibaren kalan g\u00fcn say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/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=\"geri d\u00f6nen g\u00fcnlerin say\u0131s\u0131\" width=\"580\" height=\"258\"><\/figure><\/div><p> Bu \u00f6rnekte tarih 10 \u015eubat 2023 ve TODAY taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen tarih 18 Ocak 2023&#8217;t\u00fcr. <\/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=\"d\u00f6n\u00fc\u015f tarihi\" width=\"469\" height=\"224\"><\/figure><\/div><p> Ve ileri tarihten \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda kalan g\u00fcnleri al\u0131rs\u0131n\u0131z.<\/p><p> Daha \u00f6nce de belirtti\u011fim gibi BUG\u00dcN ge\u00e7ici bir fonksiyondur ve sisteminizde tarih de\u011fi\u015fti\u011finde geri d\u00f6nd\u00fc\u011f\u00fc tarihi de de\u011fi\u015ftirerek geri say\u0131m yapar.<\/p><p> Form\u00fcl sonucunu daha anlaml\u0131 hale getirmek i\u00e7in bunu test de\u011feriyle birle\u015ftirebilirsiniz. <\/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=\"form\u00fcl\u00fc-metin-de\u011feriyle-birle\u015ftir\" 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\"> Excel dosyas\u0131n\u0131 al\u0131n<\/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\">\u0130ndirmek<\/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\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/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\/tr\/haftanin-tarihini-ekle\/\">Excel&#8217;deki bir tarihten hafta ekleme-\u00e7\u0131karma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gunun-adini-ogren\/\">Excel&#8217;deki bir tarihten g\u00fcn\u00fcn ad\u0131n\u0131 al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-gunleri\/\">Excel&#8217;de aylar\u0131n toplam g\u00fcn say\u0131s\u0131n\u0131 al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ay-is-gunu\/\">Bir ayda i\u015f g\u00fcn\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-tarihi-2\/\">Tarihi metne d\u00f6n\u00fc\u015ft\u00fcr<\/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-1691","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>Excel&#039;de geri say\u0131m g\u00fcnleri<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim size bir tarihten kalan g\u00fcnlerin dinamik geri say\u0131m\u0131n\u0131 olu\u015fturmak i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir.\" \/>\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\/tr\/geri-sayim-gunleri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de geri say\u0131m g\u00fcnleri\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim size bir tarihten kalan g\u00fcnlerin dinamik geri say\u0131m\u0131n\u0131 olu\u015fturmak i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:27+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=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/\",\"name\":\"Excel&#39;de geri say\u0131m g\u00fcnleri\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#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-10T06:01:27+00:00\",\"description\":\"Bu e\u011fitim size bir tarihten kalan g\u00fcnlerin dinamik geri say\u0131m\u0131n\u0131 olu\u015fturmak i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#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\/tr\/geri-sayim-gunleri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de geri say\u0131m g\u00fcnleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de geri say\u0131m g\u00fcnleri","description":"Bu e\u011fitim size bir tarihten kalan g\u00fcnlerin dinamik geri say\u0131m\u0131n\u0131 olu\u015fturmak i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir.","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\/tr\/geri-sayim-gunleri\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de geri say\u0131m g\u00fcnleri","og_description":"Bu e\u011fitim size bir tarihten kalan g\u00fcnlerin dinamik geri say\u0131m\u0131n\u0131 olu\u015fturmak i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir.","og_url":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:27+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":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/","url":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/","name":"Excel&#39;de geri say\u0131m g\u00fcnleri","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#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-10T06:01:27+00:00","description":"Bu e\u011fitim size bir tarihten kalan g\u00fcnlerin dinamik geri say\u0131m\u0131n\u0131 olu\u015fturmak i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/#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\/tr\/geri-sayim-gunleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de geri say\u0131m g\u00fcnleri"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1691"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1691\/revisions"}],"predecessor-version":[{"id":2522,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1691\/revisions\/2522"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}