{"id":15356,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tarihsayisi\/"},"modified":"2021-02-25T16:25:09","modified_gmt":"2021-02-25T16:25:09","slug":"datevalue","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/datevalue\/","title":{"rendered":"TAR\u0130HSAYISI"},"content":{"rendered":"

Tarihleri Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme<\/h2>\n

Excel ve Google E-Tablolar, tarihleri i\u015flerken kullan\u0131lan \u00e7ok y\u00f6nl\u00fc ara\u00e7lar sunar. Bu ara\u00e7lardan biri de DATEVALUE<\/code> (TAR\u0130HSAYISI) fonksiyonudur. Bu fonksiyon, tarihleri metin format\u0131ndan Excel’in anlayabilece\u011fi seri numara format\u0131na \u00e7evirir. Bu i\u015flem, tarihlerle matematiksel i\u015flemler yapmay\u0131 m\u00fcmk\u00fcn k\u0131lar.<\/p>\n

Fonksiyon S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

DATEVALUE<\/code> fonksiyonunun temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  =DATEVALUE(tarih_metni) <\/code> <\/pre>\n
Burada “tarih_metni” arg\u00fcman\u0131, tarih bilgisini i\u00e7eren metin bi\u00e7imindeki veridir. Excel veya Google E-Tablolar bu tarih metnini al\u0131r ve onu i\u00e7sel bir seri numaras\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p>\n
\u00d6rnek Kullan\u0131m:<\/p>\n
  =DATEVALUE(\"2021-12-25\") <\/code> <\/pre>\n
Bu form\u00fcl, “2021-12-25” tarihini Excel’in anlad\u0131\u011f\u0131 seri numaras\u0131 olan 44561’e d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p>\n
Pratik G\u00f6revler<\/h2>\n
\u0130\u015flevi \u00e7e\u015fitli senaryolarda nas\u0131l kullanabilece\u011finizi g\u00f6stermek i\u00e7in a\u015fa\u011f\u0131da iki farkl\u0131 uygulama senaryosu sunulmu\u015ftur.<\/p>\n
    \n
  • Tarih Aral\u0131\u011f\u0131 Hesaplama:<\/strong> Bir projenin ba\u015flang\u0131\u00e7 ve biti\u015f tarihi aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in DATEVALUE<\/code> fonksiyonunu kullanabilirsiniz.<\/li>\n
      =DATEVALUE(\"2024-12-31\") - DATEVALUE(\"2024-01-01\") <\/code> <\/pre>\n
    Bu form\u00fcl, y\u0131l\u0131n ilk ve son g\u00fcn\u00fc aras\u0131ndaki t\u00fcm g\u00fcn say\u0131s\u0131n\u0131 hesaplar ve 364 g\u00fcn d\u00f6nd\u00fcr\u00fcr.<\/p>\n
  • Tarih Do\u011frulama:<\/strong> E-Tablolar\u0131n\u0131za girilen tarihlerin ge\u00e7erli olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in kullanabilirsiniz. E\u011fer tarih ge\u00e7ersiz ise, DATEVALUE<\/code> fonksiyonu hata de\u011feri d\u00f6ner.<\/li>\n
      =IF(ISERROR(DATEVALUE(A2)), \"Ge\u00e7ersiz Tarih\", \"Ge\u00e7erli Tarih\") <\/code> <\/pre>\n
    Bu form\u00fcl, A2 h\u00fccresindeki tarihin ge\u00e7erlili\u011fini kontrol eder ve duruma g\u00f6re “Ge\u00e7erli Tarih” veya “Ge\u00e7ersiz Tarih” mesaj\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n<\/ul>\n
    Her iki senaryoda da, DATEVALUE<\/code> fonksiyonunu kullanmak, tarihlerle \u00e7al\u0131\u015f\u0131rken veri do\u011frulu\u011funu ve i\u015flemlerin kolayl\u0131\u011f\u0131n\u0131 art\u0131r\u0131r. \u00d6zellikle b\u00fcy\u00fck veri setleri ile \u00e7al\u0131\u015f\u0131rken, tarih format\u0131n\u0131n tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flamak i\u00e7in bu t\u00fcr fonksiyonlardan yararlanmak \u00f6nemlidir.<\/p>\n
    Sonu\u00e7<\/h2>\n
    DATEVALUE<\/code> i\u015flevi, Excel ve Google E-Tablolar’da tarih verileri \u00fczerinde \u00e7al\u0131\u015f\u0131rken temel bir ara\u00e7t\u0131r. Metinden tarih seri numaras\u0131na d\u00f6n\u00fc\u015f\u00fcm yaparak, tarihlerle ilgili \u00e7e\u015fitli hesaplamalar\u0131 ve do\u011frulamalar\u0131 m\u00fcmk\u00fcn k\u0131lar. Kullan\u0131c\u0131lar bu fonksiyon sayesinde, tarih verilerini daha etkin ve do\u011fru bir \u015fekilde kullanabilirler.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metin bi\u00e7imindeki bir tarihi seri numaras\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/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-15356","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de DATEVALUE (TAR\u0130HSAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DATEVALUE (TAR\u0130HSAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/\" \/>\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:09+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 DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/datevalue\/\",\"name\":\"Excel'de DATEVALUE (TAR\u0130HSAYISI) 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:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/datevalue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/datevalue\/#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\u0130HSAYISI\"}]},{\"@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 DATEVALUE (TAR\u0130HSAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DATEVALUE (TAR\u0130HSAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/","url":"https:\/\/functiontranslator.com\/tr\/datevalue\/","name":"Excel'de DATEVALUE (TAR\u0130HSAYISI) 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:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DATEVALUE (TAR\u0130HSAYISI) 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\/datevalue\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/datevalue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/datevalue\/#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\u0130HSAYISI"}]},{"@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\/15356","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=15356"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15356\/revisions"}],"predecessor-version":[{"id":26624,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15356\/revisions\/26624"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}