{"id":1611,"date":"2023-11-15T11:10:08","date_gmt":"2023-11-15T11:10:08","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/"},"modified":"2023-12-10T06:03:30","modified_gmt":"2023-12-10T06:03:30","slug":"yilin-gununun-numarasini-al","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/","title":{"rendered":"Excel&#39;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3523785573\"><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>Bir y\u0131lda 365 veya 366 g\u00fcn (art\u0131k y\u0131l) vard\u0131r. Ve bu derste bir tarih i\u00e7in y\u0131l i\u00e7indeki g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. Bu, 365 veya 366 g\u00fcndeki g\u00fcn say\u0131s\u0131 anlam\u0131na gelir.<\/p><h2 class=\"wp-block-heading\"> Bir tarih i\u00e7in g\u00fcn say\u0131s\u0131n\u0131 hesaplay\u0131n<\/h2><p> G\u00fcn say\u0131s\u0131n\u0131 almak i\u00e7in form\u00fcl yazmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin.<\/p><ol type=\"1\"><li> Tarihin bulundu\u011fu A1 h\u00fccresine bak\u0131n.<\/li><li> \u015eimdi eksi i\u015faretini (-) yaz\u0131n ve ard\u0131ndan tarih fonksiyonuna girin.<\/li><li> Tarih i\u015flevinde y\u0131l i\u015flevini daha fazla kullan\u0131n, ard\u0131ndan A1 h\u00fccresine bak\u0131n.<\/li><li> \u0130kinci arg\u00fcmana 1 girin ve son arg\u00fcmana 0 girin.<\/li><li> Kapatma parantezlerini girin ve Enter tu\u015funa bas\u0131n.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-DATE(YEAR(A1),1,0)<\/code><\/pre><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi A1 h\u00fccresinde 2 Nisan 2022 tarihi var ve kulland\u0131\u011f\u0131m\u0131z form\u00fcl sonu\u00e7ta 92 de\u011ferini d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64202\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"hesaplama-g\u00fcn-tarih-say\u0131s\u0131n\u0131-hesapla\" width=\"416\" height=\"250\"><\/figure><\/div><p> \u015eimdi bu form\u00fcl\u00fc anlayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64203\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-pour-obtenir-le-numero-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fcn\u00fcn say\u0131s\u0131n\u0131 elde etmek i\u00e7in form\u00fcl\" width=\"598\" height=\"217\"><\/figure><\/div><p> \u0130lk b\u00f6l\u00fcmde, bir \u00f6nceki y\u0131l\u0131n son tarihini d\u00f6nd\u00fcren, kulland\u0131\u011f\u0131n\u0131z tarih fonksiyonumuz var. Dolay\u0131s\u0131yla elimizde 2022 y\u0131l\u0131 tarihi oldu\u011fundan, tarih i\u015flevi 31-Aral\u0131k-2021 de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64204\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-premiere-partie-de-la-formule-du-numero-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"G\u00fcn\u00fcn ilk k\u0131sm\u0131 i\u00e7in numaraland\u0131rma form\u00fcl\u00fc\" width=\"522\" height=\"262\"><\/figure><\/div><p> 02 Nisan 2022 tarihinden 31 Aral\u0131k 2021 tarihini \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda sonu\u00e7ta 2022 y\u0131l\u0131n\u0131n 02 Nisan 2022 g\u00fcn say\u0131s\u0131 olan 92 elde edilir.<\/p><p> Excel&#8217;in tarihi say\u0131 olarak saklad\u0131\u011f\u0131n\u0131 unutmaman\u0131z gereken bir nokta var. Bir h\u00fccreye 1 girip bunu tarih olarak bi\u00e7imlendirdi\u011finizde Excel bunu 01-Ocak-1990 olarak g\u00f6r\u00fcnt\u00fcler.<\/p><p> \u015eimdi 02 Nisan 2022 tarihinin say\u0131s\u0131 44653, 31 Aral\u0131k 2021 tarihinin say\u0131s\u0131 ise 44561 olup, iki say\u0131 aras\u0131ndaki fark 92&#8217;dir. <\/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\"> 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\/obtenir-le-numero-du-jour.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\/bugune-yil-ekle\/\">Excel&#8217;de bug\u00fcne kadar y\u0131l ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-yillari-say\/\">Excel&#8217;de iki tarih aras\u0131ndaki y\u0131llar\u0131 say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2-yil-hizmet-al\/\">Excel&#8217;de y\u0131llarca hizmet al\u0131n<\/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\/tr\/tarihler-arasindaki-yillar\/\">Excel&#8217;de tarihler aras\u0131ndaki y\u0131llar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yil-ayi-cikar\/\">Excel&#8217;deki bir tarihten y\u0131l\u0131 veya ay\u0131 \u00e7\u0131kar\u0131n (Al\u0131n)<\/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-1611","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;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r? - Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"Bu Excel form\u00fclleri e\u011fitiminde, bir tarihin t\u00fcm g\u00fcnleri aras\u0131ndan bir tarihin g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 (\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131) \u00f6\u011freneceksiniz.\" \/>\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\/yilin-gununun-numarasini-al\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r? - Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"Bu Excel form\u00fclleri e\u011fitiminde, bir tarihin t\u00fcm g\u00fcnleri aras\u0131ndan bir tarihin g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 (\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131) \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:03:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.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\/yilin-gununun-numarasini-al\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/\",\"name\":\"Excel&#39;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r? - Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\",\"datePublished\":\"2023-11-15T11:10:08+00:00\",\"dateModified\":\"2023-12-10T06:03:30+00:00\",\"description\":\"Bu Excel form\u00fclleri e\u011fitiminde, bir tarihin t\u00fcm g\u00fcnleri aras\u0131ndan bir tarihin g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 (\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131) \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r?\"}]},{\"@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;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r? - Excel Dan\u0131\u015fman\u0131","description":"Bu Excel form\u00fclleri e\u011fitiminde, bir tarihin t\u00fcm g\u00fcnleri aras\u0131ndan bir tarihin g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 (\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131) \u00f6\u011freneceksiniz.","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\/yilin-gununun-numarasini-al\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r? - Excel Dan\u0131\u015fman\u0131","og_description":"Bu Excel form\u00fclleri e\u011fitiminde, bir tarihin t\u00fcm g\u00fcnleri aras\u0131ndan bir tarihin g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 (\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131) \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:03:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.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\/yilin-gununun-numarasini-al\/","url":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/","name":"Excel&#39;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r? - Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png","datePublished":"2023-11-15T11:10:08+00:00","dateModified":"2023-12-10T06:03:30+00:00","description":"Bu Excel form\u00fclleri e\u011fitiminde, bir tarihin t\u00fcm g\u00fcnleri aras\u0131ndan bir tarihin g\u00fcn say\u0131s\u0131n\u0131 nas\u0131l alaca\u011f\u0131n\u0131z\u0131 (\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131) \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yilin-gununun-numarasini-al\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;deki bir tarihten g\u00fcnler nas\u0131l \u00e7\u0131kar\u0131l\u0131r?"}]},{"@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\/1611","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=1611"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1611\/revisions"}],"predecessor-version":[{"id":2658,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1611\/revisions\/2658"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}