{"id":15355,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tarihfarki\/"},"modified":"2021-02-25T16:25:06","modified_gmt":"2021-02-25T16:25:06","slug":"datedif","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/datedif\/","title":{"rendered":"TAR\u0130HFARKI"},"content":{"rendered":"

Tarihler Aras\u0131ndaki Fark\u0131n Hesaplanmas\u0131<\/h2>\n

Tarihler aras\u0131ndaki fark\u0131 hesaplamak i\u00e7in hem Microsoft Excel hem de Google E-Tablolar’da kullan\u0131labilecek bir i\u015flev olan DATEDIF (TAR\u0130HFARKI), iki tarih aras\u0131ndaki g\u00fcn, ay veya y\u0131l fark\u0131n\u0131 hesaplar. Bu y\u00f6ntem, projelerde zaman y\u00f6netimi, finansal analizler ve e\u011fitim materyallerinde s\u0131kl\u0131kla kullan\u0131lmaktad\u0131r.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

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

  =DATEDIF(ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, \"birim\") <\/code> <\/pre>\n
burada “ba\u015flang\u0131\u00e7_tarihi” ve “biti\u015f_tarihi” hesaplamak istedi\u011finiz d\u00f6nemin s\u0131n\u0131rlar\u0131n\u0131 belirtir. “birim” ise hesaplanacak zaman birimini g\u00f6sterir ve a\u015fa\u011f\u0131daki \u00fc\u00e7 de\u011ferden birini alabilir:<\/p>\n
    \n
  • “Y” – Y\u0131llar cinsinden fark.<\/li>\n
  • “M” – Aylar cinsinden fark.<\/li>\n
  • “D” – G\u00fcnler cinsinden fark.<\/li>\n<\/ul>\n
    \u0130\u015fte birka\u00e7 \u00f6rnek kullan\u0131m:<\/p>\n
      =DATEDIF(\"01.01.2020\", \"01.01.2023\", \"Y\") <\/code> <\/pre>\n
    Bu form\u00fcl, 1 Ocak 2020 ile 1 Ocak 2023 aras\u0131ndaki tam y\u0131l say\u0131s\u0131n\u0131 hesaplayacakt\u0131r ve sonu\u00e7 3 olacakt\u0131r.<\/p>\n
      =DATEDIF(\"01.01.2020\", \"01.01.2023\", \"M\") <\/code> <\/pre>\n
    Bu \u00f6rnekte, iki tarih aras\u0131ndaki ay say\u0131s\u0131 hesaplan\u0131r ve sonu\u00e7 36 olarak \u00e7\u0131kacakt\u0131r.<\/p>\n
      =DATEDIF(\"01.01.2020\", \"01.03.2020\", \"D\") <\/code> <\/pre>\n
    Bu son \u00f6rnek, 1 Ocak 2020 ile 1 Mart 2020 aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 g\u00f6sterir ve 60 g\u00fcn oldu\u011funu bulur.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    DATEDIF i\u015flevi, ger\u00e7ek d\u00fcnya senaryolar\u0131nda \u00e7e\u015fitli yollarla kullan\u0131labilir. \u0130\u015fte iki pratik \u00f6rnek:<\/p>\n
    Zaman Bazl\u0131 Proje Takibi<\/h3>\n
    Proje y\u00f6netiminde, bir projenin ba\u015flang\u0131\u00e7 ve biti\u015f tarihleri aras\u0131ndaki s\u00fcrenin takibi i\u00e7in DATEDIF i\u015flevi kullan\u0131labilir. \u00d6rne\u011fin, bir projenin planlanan s\u00fcresini ve ger\u00e7ekle\u015fen s\u00fcresini kar\u015f\u0131la\u015ft\u0131rmak isteyebiliriz. Diyelim ki projenin planlanan ba\u015flang\u0131\u00e7 tarihi 01.01.2020 ve biti\u015f tarihi 01.06.2020’dir:<\/p>\n
      Planlanan s\u00fcre =DATEDIF(\"01.01.2020\", \"01.06.2020\", \"M\") <\/code> <\/pre>\n
    Ve ger\u00e7ek biti\u015f tarihi 01.08.2020 olsun:<\/p>\n
      Ger\u00e7ek s\u00fcre =DATEDIF(\"01.01.2020\", \"01.08.2020\", \"M\") <\/code> <\/pre>\n
    Planlanan s\u00fcre 5 ayken, ger\u00e7ekte 7 ay s\u00fcrd\u00fc\u011f\u00fcn\u00fc hesaplama imkan\u0131 sunar.<\/p>\n
    Ya\u015f Hesaplama<\/h3>\n
    Bir ki\u015finin ya\u015f\u0131n\u0131 hesaplamak i\u00e7in DATEDIF i\u015flevi s\u0131k\u00e7a kullan\u0131l\u0131r. \u00d6rne\u011fin, bir ki\u015finin do\u011fum tarihi 03.05.1995 ise ve ya\u015f\u0131n\u0131 bug\u00fcn itibariyle (varsayal\u0131m bug\u00fcn\u00fcn tarihi 01.12.2023) hesaplamak istiyorsak:<\/p>\n
      Ya\u015f =DATEDIF(\"03.05.1995\", \"01.12.2023\", \"Y\") <\/code> <\/pre>\n
    Bu form\u00fcl, ki\u015finin ya\u015f\u0131n\u0131 tam y\u0131l olarak hesaplar ve 28 olarak g\u00f6sterir. Bu, \u00f6zellikle do\u011fum g\u00fcn\u00fc hen\u00fcz gelmemi\u015fse, ger\u00e7ek ya\u015f\u0131ndan bir y\u0131l eksik olabilir. Bu t\u00fcr durumlar i\u00e7in ek ay ve g\u00fcn kontrol\u00fc yap\u0131lmas\u0131 uygundur.<\/p>\n
    \u00dcstteki \u00f6rneklerde g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, DATEDIF i\u015flevi hem i\u015f hem de ki\u015fisel veri analizinde kolayl\u0131kla kullan\u0131labilir. Yarat\u0131c\u0131 bir \u015fekilde kullan\u0131ld\u0131\u011f\u0131nda, zamanla ilgili pek \u00e7ok farkl\u0131 t\u00fcrde bilgiyi \u00e7\u0131karmak i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7 haline gelir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki tarih aras\u0131ndaki g\u00fcn, ay veya y\u0131l say\u0131s\u0131n\u0131 hesaplar Bu i\u015flev, bir ya\u015f hesaplaman\u0131z gereken form\u00fcllerde faydal\u0131d\u0131r<\/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-15355","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de DATEDIF (TAR\u0130HFARKI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DATEDIF (TAR\u0130HFARKI) 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\/datedif\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DATEDIF (TAR\u0130HFARKI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DATEDIF (TAR\u0130HFARKI) 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\/datedif\/\" \/>\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:25:06+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 DATEDIF (TAR\u0130HFARKI) 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\/datedif\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/datedif\/\",\"name\":\"Excel'de DATEDIF (TAR\u0130HFARKI) 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:25:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DATEDIF (TAR\u0130HFARKI) 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\/datedif\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/datedif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/datedif\/#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\":\"TAR\u0130HFARKI\"}]},{\"@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 DATEDIF (TAR\u0130HFARKI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DATEDIF (TAR\u0130HFARKI) 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\/datedif\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DATEDIF (TAR\u0130HFARKI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DATEDIF (TAR\u0130HFARKI) 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\/datedif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DATEDIF (TAR\u0130HFARKI) 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\/datedif\/","url":"https:\/\/functiontranslator.com\/tr\/datedif\/","name":"Excel'de DATEDIF (TAR\u0130HFARKI) 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:25:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DATEDIF (TAR\u0130HFARKI) 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\/datedif\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/datedif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/datedif\/#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":"TAR\u0130HFARKI"}]},{"@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\/15355","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=15355"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15355\/revisions"}],"predecessor-version":[{"id":27051,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15355\/revisions\/27051"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}