{"id":4884,"date":"2023-07-06T21:18:29","date_gmt":"2023-07-06T21:18:29","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/"},"modified":"2023-07-06T21:18:29","modified_gmt":"2023-07-06T21:18:29","slug":"excelde-aylik-tarihler","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/","title":{"rendered":"Excel'de ayl\u0131k tarih serisi nas\u0131l olu\u015fturulur (\u00f6rnekle)"},"content":{"rendered":"

<\/p>\n

\n

Excel’de bir dizi ayl\u0131k tarih olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =DATE(YEAR( A2<\/span> ),MONTH( A2<\/span> )+1,DAY( A2<\/span> ))\n<\/span><\/strong><\/span><\/pre>\n
 Bu form\u00fcl, ba\u015flamak istedi\u011finiz tarihin A2<\/strong> h\u00fccresine manuel olarak girildi\u011fini varsayar.<\/span><\/p>\n
 Daha sonra, tam olarak bir ay arayla aral\u0131kl\u0131 bir tarih dizisi olu\u015fturmak i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p bir s\u00fctunda istedi\u011finiz say\u0131da h\u00fccreye s\u00fcr\u00fckleyebilirsiniz.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n
 \u00d6rnek: Excel’de bir dizi ayl\u0131k tarih olu\u015fturma<\/strong><\/span><\/h2>\n
 Diyelim ki 01\/15\/2020<\/strong> ile 12\/15\/2021 tarihleri<\/strong> aras\u0131nda bir dizi ayl\u0131k tarih olu\u015fturmak istiyoruz.<\/span><\/span><\/p>\n
 Bunu yapmak i\u00e7in A2<\/strong> h\u00fccresine ilk tarihi manuel olarak girebiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 Daha sonra A3<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =DATE(YEAR( A2<\/span> ),MONTH( A2<\/span> )+1,DAY( A2<\/span> ))<\/span><\/strong><\/span><\/pre>\n
 Bu form\u00fcl, A2<\/strong> h\u00fccresindeki tarihten bir ay sonraki tarihi otomatik olarak \u00fcretecektir:<\/span> <\/p>\n
\"\"<\/p>\n
 Son olarak 12\/15\/2021<\/strong> tarihine kadar bu form\u00fcl\u00fc t\u0131klay\u0131p A s\u00fctunundaki di\u011fer h\u00fccrelere s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n
\"Excel<\/p>\n
 Sonu\u00e7, 15.01.2020<\/strong> ile 12.15.2021<\/strong> aras\u0131ndaki ayl\u0131k tarihler dizisidir.<\/span><\/p>\n
 Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/span><\/h2>\n
 Bir dizi ayl\u0131k tarih olu\u015fturmak i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fc hat\u0131rlay\u0131n:<\/span><\/p>\n
 =DATE(YEAR( A2<\/span> ),MONTH( A2<\/span> )+1,DAY( A2<\/span> ))<\/span><\/strong><\/span><\/pre>\n
 Bu form\u00fcl\u00fcn i\u015fleyi\u015fi \u015f\u00f6yle:<\/span><\/p>\n
 \u0130lk olarak, YEAR<\/strong> i\u015flevi y\u0131l\u0131 A2 h\u00fccresinden \u00e7\u0131kar\u0131r.<\/strong><\/span><\/p>\n
 Daha sonra MONTH<\/strong> i\u015flevi A2<\/strong> h\u00fccresinden ay\u0131 \u00e7\u0131kar\u0131r. Daha sonra bir sonraki aya d\u00f6nmek i\u00e7in o aya bir tane ekleriz.<\/span><\/p>\n
 Daha sonra DAY<\/strong> i\u015flevi A2<\/strong> h\u00fccresinden g\u00fcn\u00fc \u00e7\u0131kar\u0131r.<\/span><\/p>\n
 Son olarak, son seri numaras\u0131n\u0131 tan\u0131nabilir bir tarihe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in bu i\u015flevlerin her birini TAR\u0130H<\/strong> i\u015fleviyle sar\u0131yoruz.<\/span><\/p>\n
 Sonu\u00e7 olarak, A3<\/strong> h\u00fccresindeki, A2<\/strong> h\u00fccresindeki tarihten tam olarak bir ay sonraki bir tarihi d\u00f6nd\u00fcrebiliriz.<\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n
 Excel’de aya g\u00f6re nas\u0131l say\u0131l\u0131r<\/a>
 Excel’de ayl\u0131k ortalama nas\u0131l hesaplan\u0131r<\/a>
Excel’de tarihi ay ve y\u0131l bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Excel’de bir dizi ayl\u0131k tarih olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =DATE(YEAR( A2 ),MONTH( A2 )+1,DAY( A2 )) Bu form\u00fcl, ba\u015flamak istedi\u011finiz tarihin A2 h\u00fccresine manuel olarak girildi\u011fini varsayar. Daha sonra, tam olarak bir ay arayla aral\u0131kl\u0131 bir tarih dizisi olu\u015fturmak i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p bir s\u00fctunda istedi\u011finiz say\u0131da h\u00fccreye s\u00fcr\u00fckleyebilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4884","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Ayl\u0131k Tarih Serisi Nas\u0131l Olu\u015fturulur (\u00d6rnek ile) - Stat\u00fcler<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel'de bir dizi ayl\u0131k tarihin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de Ayl\u0131k Tarih Serisi Nas\u0131l Olu\u015fturulur (\u00d6rnek ile) - Stat\u00fcler\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel'de bir dizi ayl\u0131k tarihin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T21:18:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mensuel1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/\",\"name\":\"Excel'de Ayl\u0131k Tarih Serisi Nas\u0131l Olu\u015fturulur (\u00d6rnek ile) - Stat\u00fcler\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-06T21:18:29+00:00\",\"dateModified\":\"2023-07-06T21:18:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel'de bir dizi ayl\u0131k tarihin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de ayl\u0131k tarih serisi nas\u0131l olu\u015fturulur (\u00f6rnekle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de Ayl\u0131k Tarih Serisi Nas\u0131l Olu\u015fturulur (\u00d6rnek ile) - Stat\u00fcler","description":"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel'de bir dizi ayl\u0131k tarihin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Ayl\u0131k Tarih Serisi Nas\u0131l Olu\u015fturulur (\u00d6rnek ile) - Stat\u00fcler","og_description":"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel'de bir dizi ayl\u0131k tarihin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/","og_site_name":"Statorials","article_published_time":"2023-07-06T21:18:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mensuel1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/","url":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/","name":"Excel'de Ayl\u0131k Tarih Serisi Nas\u0131l Olu\u015fturulur (\u00d6rnek ile) - Stat\u00fcler","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-06T21:18:29+00:00","dateModified":"2023-07-06T21:18:29+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel'de bir dizi ayl\u0131k tarihin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-aylik-tarihler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de ayl\u0131k tarih serisi nas\u0131l olu\u015fturulur (\u00f6rnekle)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4884"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4884\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}