{"id":15387,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/seritarih\/"},"modified":"2021-02-25T16:26:21","modified_gmt":"2021-02-25T16:26:21","slug":"edate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/edate\/","title":{"rendered":"SER\u0130TAR\u0130H"},"content":{"rendered":"

Excel ve Google E-Tablolar \u0130\u00e7in EDATE\/SER\u0130TAR\u0130H \u0130\u015flevinin Detayl\u0131 Rehberi<\/h1>\n

EDATE ya da Google E-Tablolar’daki kar\u015f\u0131l\u0131\u011f\u0131 SER\u0130TAR\u0130H i\u015flevi, belirtilen ba\u015flang\u0131\u00e7 tarihinden itibaren belirli say\u0131da ay sonras\u0131nda veya \u00f6ncesindeki tarihi hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu i\u015flev, finansal analizler, proje planlamalar\u0131 ve herhangi bir tarih bazl\u0131 hesaplama gerektiren i\u015flemler i\u00e7in olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n

S\u00f6zdiziminin A\u00e7\u0131klamas\u0131 ve \u00d6rnekler<\/h2>\n

EDATE i\u015flevinin temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 EDATE(ba\u015flang\u0131\u00e7_tarihi, ay)<\/code> <\/pre>\n
Burada:<\/p>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/strong> \u0130\u015fleme tabi tutulacak tarihtir ve tarih format\u0131nda olmal\u0131d\u0131r.<\/li>\n
  • ay:<\/strong> Ba\u015flang\u0131\u00e7 tarihinden itibaren ge\u00e7ecek veya geriye gidecek ay say\u0131s\u0131n\u0131 belirtir. Pozitif de\u011ferler gelecek aylar\u0131, negatif de\u011ferler ge\u00e7mi\u015f aylar\u0131 temsil eder.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
     EDATE(\"2023-01-01\", 3)<\/code> <\/pre>\n
    Bu form\u00fcl, 2023 y\u0131l\u0131 1 Ocak’tan itibaren 3 ay sonraki tarihi, yani 2023 y\u0131l\u0131n\u0131n Nisan ay\u0131n\u0131n 1’ini d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131 ve Detayl\u0131 A\u00e7\u0131klamalar\u0131<\/h2>\n
    Senaryo 1: Proje Biti\u015f Tarihinin Hesaplanmas\u0131<\/h3>\n
    EDATE i\u015flevi, bir projenin ba\u015flang\u0131\u00e7 tarihinden itibaren belirlenen s\u00fcre sonunda biti\u015f tarihini hesaplamak i\u00e7in kullan\u0131labilir. \u00d6rne\u011fin, bir projenin 2023 y\u0131l\u0131nda 15 Ocak’ta ba\u015flamas\u0131 ve 18 ay s\u00fcrmesi bekleniyorsa:<\/p>\n
     EDATE(\"2023-01-15\", 18)<\/code> <\/pre>\n
    Bu form\u00fcl, projenin biti\u015f tarihinin 2024 y\u0131l\u0131n\u0131n Temmuz ay\u0131n\u0131n 15’i olaca\u011f\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bu, proje y\u00f6neticileri ve tak\u0131m \u00fcyeleri i\u00e7in \u00f6nemli bir planlama arac\u0131d\u0131r.<\/p>\n
    Senaryo 2: Finansal Tarih Hesaplamalar\u0131<\/h3>\n
    EDATE i\u015flevi finansal hesaplamalarda da kullan\u0131labilir. \u00d6rne\u011fin, bir kredi taksitinin ba\u015flang\u0131\u00e7 tarihinden 12 ay sonras\u0131n\u0131n hesaplanmas\u0131 gerekiyorsa:<\/p>\n
     EDATE(\"2023-02-01\", 12)<\/code> <\/pre>\n
    Bu, kredi taksitinin 2024 y\u0131l\u0131 \u015eubat ay\u0131n\u0131n 1’inde \u00f6denmesi gerekti\u011fini g\u00f6sterir. Bankalar ve bor\u00e7lular i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131 bir hesaplama y\u00f6ntemidir.<\/p>\n<\/article>\n","protected":false},"excerpt":{"rendered":"
    Ba\u015flang\u0131\u00e7 tarihinden itibaren, belirtilen ay say\u0131s\u0131ndan \u00f6nce veya sonraki tarihin seri numaras\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[588],"tags":[],"class_list":["post-15387","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da EDATE (SER\u0130TAR\u0130H) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/edate\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da EDATE (SER\u0130TAR\u0130H) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/edate\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:26:21+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/tr\/edate\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/edate\/\",\"name\":\"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:26:21+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da EDATE (SER\u0130TAR\u0130H) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/edate\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/edate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/edate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tarih ve saat\",\"item\":\"https:\/\/functiontranslator.com\/tr\/tarih-ve-saat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SER\u0130TAR\u0130H\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da EDATE (SER\u0130TAR\u0130H) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/edate\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da EDATE (SER\u0130TAR\u0130H) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/edate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:21+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/edate\/","url":"https:\/\/functiontranslator.com\/tr\/edate\/","name":"Excel'de EDATE (SER\u0130TAR\u0130H) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:26:21+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da EDATE (SER\u0130TAR\u0130H) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/edate\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/edate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/edate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Tarih ve saat","item":"https:\/\/functiontranslator.com\/tr\/tarih-ve-saat\/"},{"@type":"ListItem","position":3,"name":"SER\u0130TAR\u0130H"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15387"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15387\/revisions"}],"predecessor-version":[{"id":26655,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15387\/revisions\/26655"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}