{"id":15563,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/simdi\/"},"modified":"2021-02-25T16:32:59","modified_gmt":"2021-02-25T16:32:59","slug":"now","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/now\/","title":{"rendered":"\u015e\u0130MD\u0130"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, hem profesyonel hem de ki\u015fisel i\u015flerinizde s\u0131k kullanabilece\u011finiz g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu ara\u00e7larda bulunan kullan\u0131\u015fl\u0131 fonksiyonlardan biri &#8220;NOW&#8221; (\u015e\u0130MD\u0130) fonksiyonudur. Bu fonksiyon, mevcut tarih ve saati g\u00f6stererek ger\u00e7ek zamanl\u0131 veri i\u015fleme ve zaman damgas\u0131 olu\u015fturmaya imkan tan\u0131r. A\u015fa\u011f\u0131da, NOW fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131, yayg\u0131n kullan\u0131m senaryolar\u0131 ve pratik \u00f6rneklerini inceleyece\u011fiz.<\/p>\n<h2>\u015e\u0130MD\u0130 Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n<p>\u015e\u0130MD\u0130 fonksiyonu, herhangi bir arg\u00fcman gerektirmez ve kullan\u0131m kolayl\u0131\u011f\u0131 nedeniyle s\u0131k\u00e7a tercih edilir. \u0130\u015fte temel kullan\u0131m\u0131:<\/p>\n<pre><code>=NOW()<\/code><\/pre>\n<p>Bu fonksiyon \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda, sistem tarihini ve saatini y\u0131l, ay, g\u00fcn, saat, dakika ve saniye format\u0131nda geri d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h2>Uygulamal\u0131 \u00d6rnekler<\/h2>\n<p>\u015eimdi, NOW fonksiyonunun iki farkl\u0131 kullan\u0131m senaryosunu g\u00f6zden ge\u00e7irece\u011fiz.<\/p>\n<h2>Zaman Damgas\u0131 Olu\u015fturma<\/h2>\n<p>Elektronik tablolarda yap\u0131lan de\u011fi\u015fiklikleri zaman damgalar\u0131 ile izleyebilirsiniz. \u00d6rne\u011fin, bir sipari\u015f listesi \u00fczerinde \u00e7al\u0131\u015f\u0131rken, her bir sipari\u015fin girildi\u011fi tarihi ve saati otomatik olarak kaydedebilirsiniz.<\/p>\n<ul>\n<li>Bir sipari\u015fin girildi\u011fi h\u00fccrenin yan\u0131na, yeni bir h\u00fccreye =NOW() fonksiyonunu ekleyerek, sipari\u015fin girildi\u011fi an\u0131n tarih ve saatini kaydedebilirsiniz.<\/li>\n<\/ul>\n<pre><code>Sipari\u015f No | Giri\u015f Zaman\u0131 102 | =NOW() 103 | =NOW() <\/code><\/pre>\n<h2>Rapor Tarihlerini G\u00fcncel Tutmak<\/h2>\n<p>Raporlar\u0131n ba\u015fl\u0131k k\u0131sm\u0131na g\u00fcncel tarihi otomatik olarak eklemek i\u00e7in bu fonksiyonu kullanabilirsiniz. D\u00fczenli olarak g\u00fcncellenen ve g\u00f6zden ge\u00e7irilen raporlar i\u00e7in ideal bir y\u00f6ntemdir. Form\u00fcl\u00fc bir kez girdi\u011finizde, her dosya a\u00e7\u0131ld\u0131\u011f\u0131nda tarih otomatik olarak g\u00fcncellenir.<\/p>\n<pre><code>Rapor Tarihi: =NOW()<\/code><\/pre>\n<p>Bu kullan\u0131m, belgenin her a\u00e7\u0131ld\u0131\u011f\u0131nda tarihin g\u00fcncellenmesini sa\u011flar ve raporun en son ne zaman incelendi\u011fini belirlemenize yard\u0131mc\u0131 olur.<\/p>\n<p>\u015e\u0130MD\u0130 fonksiyonun kullan\u0131m\u0131 genel olarak bu \u015fekildedir. Excel ve Google Sheets gibi ara\u00e7lar\u0131 bu gibi fonksiyonlarla daha verimli bir \u015fekilde kullanarak hem zaman tasarrufu sa\u011flayabilir hem de i\u015flerinizi daha d\u00fczenli y\u00fcr\u00fctebilirsiniz. \u0130\u015f s\u00fcre\u00e7lerinizi otomatize etmek ve verilerinizi g\u00fcncel tutmak i\u00e7in bu t\u00fcr fonksiyonlar\u0131 entegre etmeyi d\u00fc\u015f\u00fcn\u00fcn.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ge\u00e7erli tarih ve saatin 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-15563","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de NOW (\u015e\u0130MD\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da NOW (\u015e\u0130MD\u0130) 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\/now\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de NOW (\u015e\u0130MD\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da NOW (\u015e\u0130MD\u0130) 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\/now\/\" \/>\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:32:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de NOW (\u015e\u0130MD\u0130) 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\/now\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/now\/\",\"name\":\"Excel'de NOW (\u015e\u0130MD\u0130) 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:32:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NOW (\u015e\u0130MD\u0130) 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\/now\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/now\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/now\/#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\":\"\u015e\u0130MD\u0130\"}]},{\"@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 NOW (\u015e\u0130MD\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NOW (\u015e\u0130MD\u0130) 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\/now\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NOW (\u015e\u0130MD\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NOW (\u015e\u0130MD\u0130) 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\/now\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:32:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NOW (\u015e\u0130MD\u0130) 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\/now\/","url":"https:\/\/functiontranslator.com\/tr\/now\/","name":"Excel'de NOW (\u015e\u0130MD\u0130) 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:32:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NOW (\u015e\u0130MD\u0130) 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\/now\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/now\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/now\/#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":"\u015e\u0130MD\u0130"}]},{"@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\/15563","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=15563"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15563\/revisions"}],"predecessor-version":[{"id":26831,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15563\/revisions\/26831"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}