{"id":2108,"date":"2023-10-15T14:09:29","date_gmt":"2023-10-15T14:09:29","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/"},"modified":"2023-12-10T05:59:59","modified_gmt":"2023-12-10T05:59:59","slug":"excel-tarih-fonksiyonlari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/","title":{"rendered":"Excel tarih i\u0307\u015flevleri"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3643332657\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p><strong><em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel_date_functions_sample_files.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\u00d6rnek dosyalar<\/a><\/em><\/strong><\/p><h2 class=\"wp-block-heading\"> 1. TAR\u0130H i\u015flevi<\/h2><p> DATE i\u015flevi, girdi\u011finiz g\u00fcn, ay ve y\u0131la g\u00f6re ge\u00e7erli bir tarih d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, t\u00fcm tarih bile\u015fenlerini belirtmeniz gerekir ve bundan bir tarih olu\u015fturulur.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em><strong>TAR\u0130H(y\u0131l,ay,g\u00fcn)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>y\u0131l:<\/strong> y\u0131l olarak kullan\u0131lacak say\u0131.<\/li><li> <strong>ay:<\/strong> ay olarak kullan\u0131lacak say\u0131.<\/li><li> <strong>g\u00fcn:<\/strong> g\u00fcn olarak kullan\u0131lacak say\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte tarih olu\u015fturmak amac\u0131yla y\u0131l\u0131, ay\u0131 ve g\u00fcn\u00fc belirtmek i\u00e7in h\u00fccre referanslar\u0131n\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55540\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tarih-i\u015flevi-\u00f6rnek-1\" width=\"587\" height=\"390\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte g\u00f6rebilece\u011finiz gibi bir tarih olu\u015fturmak i\u00e7in do\u011frudan fonksiyona arg\u00fcmanlar da ekleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55541\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"383\" height=\"164\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, fonksiyonun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc sonucu g\u00f6rmek i\u00e7in farkl\u0131 t\u00fcrde arg\u00fcmanlar kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55542\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"552\" height=\"376\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 2. TAR\u0130H DE\u011eER\u0130 i\u015flevi<\/h2><p> DATEVALUE i\u015flevi, metni (bir tarihi temsil eden) ger\u00e7ek bir tarihe d\u00f6n\u00fc\u015ft\u00fcrd\u00fckten sonra bir tarih d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, bir tarihi, metin olarak bi\u00e7imlendirilmi\u015f ger\u00e7ek bir tarihe d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em><strong>DE\u011eERTAR\u0130H(metin_tarihi)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>tarih_metni:<\/strong> Metin olarak saklanan ve bu metni ger\u00e7ek bir tarihe d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz tarih.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, \u00e7ift t\u0131rnak kullanarak do\u011frudan fonksiyona tarih ekledik. Bu al\u0131nt\u0131lar\u0131 eklemeyi atlarsan\u0131z #NAME mi d\u00f6nd\u00fcr\u00fcl\u00fcr? sonu\u00e7 hatas\u0131. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36901\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-datevalue-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tarih de\u011feri-i\u015flev-\u00f6rnek-1\" width=\"595\" height=\"356\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte sol taraftaki t\u00fcm tarihler metin bi\u00e7imindedir.<\/p><ol><li> Ge\u00e7erli bir tarihe d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fcm\u00fcz basit bir metin tarihi.<\/li><li> Say\u0131larla \u00fc\u00e7 bile\u015fenin (y\u0131l, ay veya g\u00fcn) tamam\u0131n\u0131 i\u00e7eren bir tarih.<\/li><li> Metin tarihinde y\u0131l yoksa y\u0131l olarak i\u00e7inde bulunulan y\u0131l al\u0131nacakt\u0131r.<\/li><li> Ve e\u011fer alfabetik olarak bir ay ad\u0131n\u0131z varsa ve y\u0131l\u0131n\u0131z yoksa, i\u00e7inde bulundu\u011funuz y\u0131l\u0131 y\u0131l olarak alacakt\u0131r.<\/li><li> Metin tarihinizde g\u00fcn yoksa g\u00fcn numaras\u0131 olarak 1 al\u0131nacakt\u0131r. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36903\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-datevalue-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tarihde\u011feri-fonksiyonu-\u00f6rnek-2\" width=\"606\" height=\"423\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 3.G\u00dcN i\u015flevi<\/h2><p> DAY i\u015flevi ge\u00e7erli bir tarihten ba\u015flayarak g\u00fcn say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bildi\u011finiz gibi Excel&#8217;de tarih g\u00fcn, ay ve y\u0131l\u0131n birle\u015fiminden olu\u015fur, DAY i\u015flevi tarihten g\u00fcn\u00fc al\u0131r ve geri kalan k\u0131sm\u0131 yok sayar.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em><strong>DAY(seri_numaras\u0131)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>seri_numaras\u0131:<\/strong> bug\u00fcn\u00fcn numaras\u0131n\u0131 \u00e7\u0131karmak istedi\u011finiz tarihin ge\u00e7erli seri numaras\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir tarihten sadece g\u00fcn\u00fc almak i\u00e7in DAY ifadesini kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36905\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-jour-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-g\u00fcn-fonksiyonu-\u00f6rnek-1\" width=\"555\" height=\"239\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, ge\u00e7erli g\u00fcn say\u0131s\u0131n\u0131 d\u00f6nd\u00fcren ve \u00e7al\u0131\u015fma sayfan\u0131z\u0131 her a\u00e7t\u0131\u011f\u0131n\u0131zda veya \u00e7al\u0131\u015fma sayfan\u0131z\u0131 yeniden hesaplad\u0131\u011f\u0131n\u0131zda g\u00fcncellenecek dinamik bir form\u00fcl olu\u015fturmak i\u00e7in DAY ile BUG\u00dcN&#8217;\u00fc kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36907\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-jour-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-g\u00fcn-fonksiyonu-\u00f6rnek-2\" width=\"571\" height=\"281\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 5.G\u00dcN i\u015flevi<\/h2><p> DAYS i\u015flevi iki tarih aras\u0131ndaki fark\u0131 d\u00f6nd\u00fcr\u00fcr. Bir ba\u015flang\u0131\u00e7 tarihi ve biti\u015f tarihi al\u0131r ve ard\u0131ndan aralar\u0131ndaki fark\u0131 g\u00fcn olarak d\u00f6nd\u00fcr\u00fcr. Bu i\u015flev Excel 2013&#8217;te tan\u0131t\u0131ld\u0131 ve bu nedenle \u00f6nceki s\u00fcr\u00fcmlerde mevcut de\u011fil.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>G\u00dcNLER(biti\u015f_tarihi,ba\u015flang\u0131\u00e7_tarihi)<\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>start_date:<\/strong> Bu, g\u00fcnleri hesaplamaya ba\u015flamak istedi\u011finiz ge\u00e7erli bir tarihtir.<\/li><li> <strong>biti\u015f_tarihi:<\/strong> Bu, g\u00fcn hesaplamas\u0131n\u0131 sonland\u0131rmak istedi\u011finiz ge\u00e7erli bir tarihtir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1 h\u00fccresini ba\u015flang\u0131\u00e7 tarihi, B1 h\u00fccresini ise biti\u015f tarihi olarak belirttik ve sonu\u00e7ta 9 g\u00fcn\u00fcm\u00fcz var.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> \u0130ki tarih aras\u0131ndaki fark\u0131 bulmak i\u00e7in \u00e7\u0131karma operat\u00f6r\u00fcn\u00fc de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36909\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-jours-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-g\u00fcnler-i\u015flevi-\u00f6rnek-1\" width=\"508\" height=\"261\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, aralar\u0131ndaki fark\u0131 bulmak i\u00e7in do\u011frudan fonksiyona iki tarih ekledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36911\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-jours-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-g\u00fcnler-i\u015flevi-\u00f6rnek-2\" width=\"484\" height=\"301\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 6. EDATE i\u015flevi<\/h2><p> EDATE i\u015flevi, belirli say\u0131da ay eklendikten sonra bir tarih d\u00f6nd\u00fcr\u00fcr. Basit\u00e7e s\u00f6ylemek gerekirse, bir tarihten aylar ekleyebilir (pozitif bir say\u0131yla) veya (negatif bir say\u0131yla) \u00e7\u0131karabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em><strong>EDTAR\u0130H(ba\u015flang\u0131\u00e7_tarihi,ay)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>start_date:<\/strong> hesaplamay\u0131 ba\u015flatmak istedi\u011finiz tarih.<\/li><li> <strong>ay:<\/strong> Gelecek veya ge\u00e7mi\u015f tarihin hesaplanaca\u011f\u0131 ay say\u0131s\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> Burada EDATE&#8217;i farkl\u0131 arg\u00fcman t\u00fcrleriyle kulland\u0131k.<\/p><ul><li> \u0130lk \u00f6rnekte 5&#8217;i birden \u00e7ok ay olarak kulland\u0131k ve 1 Ocak 2016&#8217;da tam olarak 5 ay ekleyip 1 Haziran 2016&#8217;y\u0131 d\u00f6nd\u00fcrd\u00fc.<\/li><li> \u0130kinci \u00f6rnekte -1 ay kulland\u0131k ve bu da 31-Aral\u0131k-2016 sonucunu verdi; bu tarih 31-Ocak-2016&#8217;n\u0131n tam 1 ay gerisindeydi.<\/li><li> \u00dc\u00e7\u00fcnc\u00fc \u00f6rnekte do\u011frudan fonksiyona tarih ekledik. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36913\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-edate-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-edate-fonksiyon-\u00f6rnek-1\" width=\"556\" height=\"272\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 7. EOMONTH i\u015flevi<\/h2><p> EOMONTH i\u015flevi, gelecekteki veya ge\u00e7mi\u015f aylar\u0131n say\u0131s\u0131 olan ay\u0131n biti\u015f tarihini d\u00f6nd\u00fcr\u00fcr. Gelecekteki bir tarih i\u00e7in pozitif bir say\u0131, ge\u00e7en ay\u0131n tarihi i\u00e7in ise negatif bir say\u0131 kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em><strong>EOMONTH(ba\u015flang\u0131\u00e7_tarihi; ay)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>ba\u015flang\u0131\u00e7_tarihi:<\/strong> hesaplaman\u0131za ba\u015flamak istedi\u011finiz ge\u00e7erli bir tarih.<\/li><li> <strong>aylar:<\/strong> ba\u015flang\u0131\u00e7 tarihinden \u00f6nce ve sonra hesaplamak istedi\u011finiz ay say\u0131s\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte EOMONTH&#8217;u farkl\u0131 arg\u00fcman t\u00fcrleriyle kulland\u0131k: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36915\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-emonth-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-emonth-fonksiyonu-\u00f6rnek-1\" width=\"512\" height=\"313\"><\/figure><\/div><ul><li> Ba\u015flang\u0131\u00e7 tarihi olarak 01 Ocak 2016&#8217;y\u0131, gelecek tarih olarak ise 5 ay\u0131 belirttik. Haziran ay\u0131 Ocak ay\u0131ndan tam 5 ay sonra oldu\u011fu i\u00e7in sonu\u00e7ta 30 Haziran 2016&#8217;da geri geldi.<\/li><li> Daha \u00f6nce de belirtti\u011fim gibi EOMMONTH bir aydaki toplam g\u00fcn say\u0131s\u0131n\u0131 tahmin edecek kadar ak\u0131ll\u0131d\u0131r.<\/li><li> Negatif bir say\u0131dan bahsederseniz, bu yaln\u0131zca bahsetti\u011finiz aylar\u0131n say\u0131s\u0131 olan ge\u00e7mi\u015f bir tarihi d\u00f6nd\u00fcr\u00fcr.<\/li><li> D\u00f6rd\u00fcnc\u00fc \u00f6rnekte ise text format\u0131nda tarih kulland\u0131k ve hata vermeden tarih d\u00f6nd\u00fcrd\u00fc.<\/li><\/ul><h2 class=\"wp-block-heading\"> 8. AY i\u015flevi<\/h2><p> MONTH i\u015flevi, ge\u00e7erli bir tarihten itibaren ay say\u0131s\u0131n\u0131 (0 ile 12 aras\u0131nda) d\u00f6nd\u00fcr\u00fcr. Bildi\u011finiz gibi Excel&#8217;de tarih g\u00fcn, ay ve y\u0131l\u0131n birle\u015fiminden olu\u015fur, MONTH tarihten itibaren ay\u0131 al\u0131r ve geri kalan k\u0131sm\u0131 yok sayar.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>AY(seri_numaras\u0131)<\/em><\/p><h3 class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>seri_numaras\u0131:<\/strong> ay numaras\u0131n\u0131 almak istedi\u011finiz ge\u00e7erli bir tarih.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte MONTH&#8217;u \u00fc\u00e7 farkl\u0131 \u015fekilde kulland\u0131k: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37201\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-mois-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ay-i\u015flevi-\u00f6rnek-1\" width=\"442\" height=\"336\"><\/figure><\/div><ul><li> \u0130LK \u00f6rnekte sadece tarihi kulland\u0131k ve sonu\u00e7ta MAYIS ay\u0131n\u0131n ay say\u0131s\u0131 olan 5 de\u011ferini d\u00f6nd\u00fcrd\u00fc.<\/li><li> \u0130K\u0130NC\u0130 \u00f6rnekte tarihi do\u011frudan fonksiyonda sa\u011flad\u0131k.<\/li><li> \u00dc\u00c7\u00dcNC\u00dc \u00f6rnekte, ge\u00e7erli tarihi almak i\u00e7in BUG\u00dcN i\u015flevini kulland\u0131k ve AY, ay say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrd\u00fc.<\/li><\/ul><h2 class=\"wp-block-heading\"> 9. \u00c7ALI\u015eMA G\u00dcNLER\u0130 fonksiyonu<\/h2><p> TAMWORKDAYS i\u015flevi, ba\u015flang\u0131\u00e7 tarihi ile biti\u015f tarihi aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle TAM\u0130\u015e G\u00dcNLER\u0130 ile cumartesi ve pazar g\u00fcnleri ile resmi tatil g\u00fcnlerini (sizin belirledi\u011finiz) hari\u00e7 tutarak iki tarih aras\u0131ndaki fark\u0131 hesaplayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em><strong>\u00c7ALI\u015eMA G\u00dcNLER\u0130 (ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, tatiller)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015flang\u0131\u00e7_tarihi<\/strong> : hesaplaman\u0131za ba\u015flamak istedi\u011finiz ge\u00e7erli bir tarih.<\/li><li> <strong>biti\u015f_tarihi<\/strong> : \u0130\u015f g\u00fcnlerini hesaplamak istedi\u011finiz ge\u00e7erli bir tarih.<\/li><li> <strong>[tatil]<\/strong> : Ba\u015flang\u0131\u00e7 tarihi ile biti\u015f tarihi aras\u0131ndaki tatili temsil eden ge\u00e7erli bir tarih. Bir h\u00fccreye, h\u00fccre aral\u0131\u011f\u0131na veya tarihleri i\u00e7eren bir diziye ba\u015fvurabilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte ba\u015flang\u0131\u00e7 tarihi olarak 10 Ocak 2015&#8217;i, biti\u015f tarihi olarak ise 20 \u015eubat 2015&#8217;i belirledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37209\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-networkdays-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-a\u011fg\u00fcnleri-i\u015flevi-\u00f6rnek-1\" width=\"551\" height=\"287\"><\/figure><\/div><p> Bu iki tarih aras\u0131nda 11&#8217;i hafta sonu g\u00fcn\u00fc olmak \u00fczere 41 g\u00fcn\u00fcm\u00fcz var. Bu 11 g\u00fcn\u00fcn d\u00fc\u015f\u00fclmesiyle 30 i\u015f g\u00fcn\u00fc elde edilir.<\/p><p> \u015eimdi ayn\u0131 ba\u015flang\u0131\u00e7 ve biti\u015f tarihlerine sahip a\u015fa\u011f\u0131daki \u00f6rnekte bir tatil belirttik ve 11 hafta sonu g\u00fcn\u00fc ve 1 tatil g\u00fcn\u00fcn\u00fc \u00e7\u0131kard\u0131ktan sonra 29 i\u015f g\u00fcn\u00fc d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37210\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-networkdays-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-a\u011fg\u00fcnleri-i\u015flevi-\u00f6rnek-2\" width=\"575\" height=\"219\"><\/figure><\/div><p> Yine ayn\u0131 ba\u015flang\u0131\u00e7 ve biti\u015f tarihleriyle, hesaplamadan \u00e7\u0131karmak i\u00e7in tatil i\u00e7in \u00fc\u00e7 h\u00fccreli bir aral\u0131k kulland\u0131k ve bahsetti\u011fim 11 hafta sonu g\u00fcn\u00fc ve 3 tatil g\u00fcn\u00fcn\u00fc \u00e7\u0131kard\u0131ktan sonra 27 i\u015f g\u00fcn\u00fc geri geldi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37211\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-networkdays-fonction-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-a\u011fg\u00fcnleri-i\u015flevi-\u00f6rnek-3\" width=\"601\" height=\"283\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 10. COUNT.WORKINGDAYS.INTL i\u015flevi<\/h2><p> NETWORKDAYS.INTL \u0130\u015flev, ba\u015flang\u0131\u00e7 tarihi ile biti\u015f tarihi aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. TAMWORKDAYS&#8217;den farkl\u0131 olarak TAMWORKDAYS.INTL, hangi g\u00fcnleri hesaplaman\u0131n d\u0131\u015f\u0131nda b\u0131rakmak istedi\u011finizi belirtmenize olanak tan\u0131r.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em><strong>TAM\u0130\u015eG\u00dcNLER\u0130.ULUSLAR(ba\u015flang\u0131\u00e7_tarihi,biti\u015f_tarihi,hafta sonu,tatil)<\/strong><\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015flang\u0131\u00e7_tarihi:<\/strong> hesaplaman\u0131za ba\u015flamak istedi\u011finiz ge\u00e7erli bir tarih.<\/li><li> <strong>biti\u015f_tarihi:<\/strong> \u0130\u015f g\u00fcnlerini hesaplamak istedi\u011finiz ge\u00e7erli tarih.<\/li><li> <strong>[hafta sonu]:<\/strong> bir say\u0131, hafta sonlar\u0131n\u0131n hesaplamaya dahil edilmedi\u011fini g\u00f6sterir.<\/li><li> <strong>[tatiller]:<\/strong> Hesaplaman\u0131n d\u0131\u015f\u0131nda b\u0131rakmak istedi\u011finiz tatilleri temsil eden tarihlerin listesi.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte ba\u015flang\u0131\u00e7 tarihi olarak 01 Ocak 2015&#8217;i, biti\u015f tarihi olarak ise 20 Ocak 2015&#8217;i kulland\u0131k. Ve hafta sonu olarak Pazar&#8217;\u0131 Cumartesi&#8217;ye almak i\u00e7in 1&#8217;i belirledik. \u0130\u015flev, 6 hafta sonu g\u00fcn\u00fcn\u00fc hari\u00e7 tuttuktan 14 g\u00fcn sonra geri d\u00f6nd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37213\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-networkdays-intl-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-networkdays.intl-fonksiyon-\u00f6rnek-1\" width=\"609\" height=\"251\"><\/figure><\/div><p> A\u015fa\u011f\u0131da ayn\u0131 tarihleri kulland\u0131k. Ve hafta sonu g\u00fcnleri i\u00e7in 11&#8217;i kulland\u0131m, bu da yaln\u0131zca Pazar g\u00fcn\u00fcn\u00fc hafta sonu olarak kabul edece\u011fi anlam\u0131na geliyor. Bununla birlikte 10 Ocak 2015 tarihini de resmi tatil olarak kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37214\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-networkdays-intl-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-networkdays.intl-fonksiyon-\u00f6rnek-2\" width=\"623\" height=\"227\"><\/figure><\/div><p> \u0130ki tarih aras\u0131nda 3 Pazar g\u00fcn\u00fc ve resmi tatilimiz var. T\u00fcm bu g\u00fcnleri hari\u00e7 tuttuktan sonra i\u015flev sonu\u00e7ta 16 g\u00fcn d\u00f6nd\u00fcrd\u00fc. A\u015fa\u011f\u0131daki \u00f6rnekte tatilleri belirtmek i\u00e7in aral\u0131\u011f\u0131 kulland\u0131k. Tatil i\u00e7in birden fazla tarihiniz varsa t\u00fcm aral\u0131\u011fa ba\u015fvurabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37215\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-networkdays-intl-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-networkdays.intl-fonksiyon-\u00f6rnek-3\" width=\"655\" height=\"267\"><\/figure><\/div><p class=\"qt-tip\"> <strong>\u0130pucu:<\/strong> Tatil i\u00e7in dinamik bir aral\u0131k olu\u015fturmak istiyorsan\u0131z bunu yapmak i\u00e7in bir tablo kullanabilirsiniz. \u0130\u015f g\u00fcn\u00fc veya hafta sonu olarak say\u0131lacak \u00f6zel g\u00fcnleri se\u00e7mek istiyorsan\u0131z hafta sonu ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde a\u015fa\u011f\u0131daki bi\u00e7imi kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37216\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-networkdays-intl-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-networkdays.intl-fonksiyon-\u00f6rnek-4\" width=\"600\" height=\"311\"><\/figure><\/div><p> Burada 0 bir \u00e7al\u0131\u015fma g\u00fcn\u00fcn\u00fc, 1 ise \u00e7al\u0131\u015fma d\u0131\u015f\u0131 bir g\u00fcn\u00fc temsil etmektedir. Ve yedi rakam haftan\u0131n 7 g\u00fcn\u00fcn\u00fc temsil ediyor.<\/p><h2 class=\"wp-block-heading\"> 11. BUG\u00dcN \u00d6zelli\u011fi<\/h2><p> BUG\u00dcN i\u015flevi, sistem tarih ve saatine g\u00f6re ge\u00e7erli tarih ve saati d\u00f6nd\u00fcr\u00fcr. \u015e\u0130MD\u0130 i\u015flevinin d\u00f6nd\u00fcrd\u00fc\u011f\u00fc tarih ve saat, \u00e7al\u0131\u015fma sayfas\u0131ndaki herhangi bir \u015feyi her g\u00fcncelledi\u011finizde s\u00fcrekli olarak g\u00fcncellenir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>BUG\u00dcN()<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> BUG\u00dcN i\u015flevinde herhangi bir arg\u00fcman yoktur, tek yapman\u0131z gereken onu h\u00fccreye yaz\u0131p enter tu\u015funa basmakt\u0131r, ancak dikkatli olun \u00e7\u00fcnk\u00fc BUG\u00dcN, elektronik tablo hesaplamalar\u0131n\u0131z\u0131 her g\u00fcncelledi\u011finizde de\u011ferini g\u00fcncelleyen ge\u00e7ici bir i\u015flevdir.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, mevcut ay numaras\u0131n\u0131, mevcut y\u0131l\u0131 ve mevcut g\u00fcn\u00fc almak i\u00e7in TODAY i\u015flevini di\u011fer i\u015flevlerle birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37350\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-aujourdhui-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-bug\u00fcn-i\u015flev-\u00f6rnek-1\" width=\"405\" height=\"321\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 12. HAFTA G\u00dcN\u00dc i\u015flevi<\/h2><p> WEEKDAY i\u015flevi, bir tarihten itibaren haftan\u0131n g\u00fcn say\u0131s\u0131n\u0131 (0 ile 7 aras\u0131nda) d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle WEEKDAY i\u015flevi bir tarih al\u0131r ve o tarihin g\u00fcn numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>HAFTANIN G\u00dcN\u00dc (seri_numaras\u0131, [d\u00f6n\u00fc\u015f_tipi])<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>seri_numaras\u0131<\/strong> : Hafta numaras\u0131n\u0131 almak istedi\u011finiz ge\u00e7erli bir tarih.<\/li><li> <strong>[return_type]<\/strong> : Haftan\u0131n ba\u015flayaca\u011f\u0131 g\u00fcn\u00fc temsil eden bir say\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, dinamik bir hafta i\u00e7i g\u00fcn\u00fc elde etmek i\u00e7in BUG\u00dcN ile birlikte HAFTA G\u00dcN\u00dc&#8217;n\u00fc kulland\u0131k. Ge\u00e7erli tarih de\u011fi\u015fti\u011finde size haftan\u0131n g\u00fcn\u00fcn\u00fc verecektir. Haftan\u0131n g\u00fcn\u00fc de\u011fi\u015fti\u011finde de\u011fi\u015fmesi gereken belirli de\u011ferleri tetiklemek i\u00e7in kontrol panellerinizde bu y\u00f6ntemi kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37383\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-jour-de-la-semaine-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hafta i\u00e7i-i\u015flev-\u00f6rnek-1\" width=\"470\" height=\"301\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, \u00f6nce tarihin haftan\u0131n g\u00fcn\u00fcn\u00fc kontrol eden ve WEEKDAY taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen de\u011fere g\u00f6re bir &#8220;Hafta i\u00e7i&#8221; veya &#8220;Hafta Sonu&#8221; taban\u0131 d\u00f6nd\u00fcren bir form\u00fcl olu\u015fturmak i\u00e7in WEEKDAY&#8217;i IF ile birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37384\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-jour-de-la-semaine-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hafta i\u00e7i-i\u015flev-\u00f6rnek-2\" width=\"587\" height=\"344\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 13. HAFTA SAYISI i\u015flevi<\/h2><p> WEEKNUM i\u015flevi bir tarihin hafta numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle WEEKNUM, belirtti\u011finiz tarihlerin 1 ile 54 aras\u0131nda de\u011fi\u015fen hafta say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>WEEKNUM(seri_numaras\u0131,d\u00f6n\u00fc\u015f_t\u00fcr\u00fc)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>seri_numaras\u0131:<\/strong> hafta numaras\u0131n\u0131 almak istedi\u011finiz tarih.<\/li><li> <strong>[return_type]:<\/strong> Y\u0131l\u0131n ilk haftas\u0131n\u0131n ba\u015flang\u0131\u00e7 g\u00fcn\u00fcn\u00fc belirten bir say\u0131. Haftan\u0131n ba\u015flang\u0131\u00e7 tarihini belirtmek i\u00e7in iki sisteminiz var.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, ge\u00e7erli tarihin hafta numaras\u0131n\u0131 almak i\u00e7in WEEKNUM ile BUG\u00dcN&#8217;\u00fc kulland\u0131k. Tarih her de\u011fi\u015fti\u011finde hafta numaras\u0131n\u0131 otomatik olarak g\u00fcncelleyecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37385\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-numero-de-semaine-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-haftasay\u0131s\u0131-i\u015flevi-\u00f6rnek-1\" width=\"513\" height=\"319\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte anlaml\u0131 bir sonu\u00e7 i\u00e7in hafta numaras\u0131yla birlikte \u201cHafta-\u201d metnini ekledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37386\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-numero-de-semaine-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-haftasay\u0131s\u0131-i\u015flevi-\u00f6rnek-2\" width=\"522\" height=\"433\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 14. YIL i\u015flevi<\/h2><p> YIL i\u015flevi, ge\u00e7erli bir tarihten itibaren y\u0131l say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bildi\u011finiz gibi Excel&#8217;de tarih, g\u00fcn, ay ve y\u0131l\u0131n birle\u015fiminden olu\u015fur ve YIL i\u015flevi, y\u0131l\u0131 tarihten al\u0131r ve geri kalan k\u0131sm\u0131 yok sayar.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>YIL (tarih)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>tarih:<\/strong> Y\u0131l\u0131 almak istedi\u011finiz tarih.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte tarihlerden y\u0131l say\u0131s\u0131n\u0131 almak i\u00e7in y\u0131l fonksiyonunu kulland\u0131k. Verilerinizde tarihler varsa ve yaln\u0131zca y\u0131l numaras\u0131na ihtiyac\u0131n\u0131z varsa bu i\u015flevi kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37387\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-annee-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-y\u0131l-i\u015flevi-\u00f6rnek-1\" width=\"308\" height=\"425\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte ise, g\u00fcncel tarihten y\u0131l say\u0131s\u0131n\u0131 almak i\u00e7in bug\u00fcn fonksiyonunu kulland\u0131k. E-tablonuzu her yeniden hesaplad\u0131\u011f\u0131n\u0131zda her zaman y\u0131l\u0131 g\u00fcncelleyecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37388\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-annee-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-y\u0131l-i\u015flevi-\u00f6rnek-2\" width=\"453\" height=\"353\"><\/figure><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2108","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de tarih i\u015flevleri nas\u0131l kullan\u0131l\u0131r? (\u00f6rnekler)<\/title>\n<meta name=\"description\" content=\"Excel&#039;de tarih i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin. Burada \u00f6rnekler ve \u00f6rnek dosyalar verdik.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de tarih i\u015flevleri nas\u0131l kullan\u0131l\u0131r? (\u00f6rnekler)\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de tarih i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin. Burada \u00f6rnekler ve \u00f6rnek dosyalar verdik.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\",\"name\":\"Excel&#39;de tarih i\u015flevleri nas\u0131l kullan\u0131l\u0131r? (\u00f6rnekler)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png\",\"datePublished\":\"2023-10-15T14:09:29+00:00\",\"dateModified\":\"2023-12-10T05:59:59+00:00\",\"description\":\"Excel&#39;de tarih i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin. Burada \u00f6rnekler ve \u00f6rnek dosyalar verdik.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel tarih i\u0307\u015flevleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de tarih i\u015flevleri nas\u0131l kullan\u0131l\u0131r? (\u00f6rnekler)","description":"Excel&#39;de tarih i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin. Burada \u00f6rnekler ve \u00f6rnek dosyalar verdik.","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:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de tarih i\u015flevleri nas\u0131l kullan\u0131l\u0131r? (\u00f6rnekler)","og_description":"Excel&#39;de tarih i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin. Burada \u00f6rnekler ve \u00f6rnek dosyalar verdik.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"11 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/","url":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/","name":"Excel&#39;de tarih i\u015flevleri nas\u0131l kullan\u0131l\u0131r? (\u00f6rnekler)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png","datePublished":"2023-10-15T14:09:29+00:00","dateModified":"2023-12-10T05:59:59+00:00","description":"Excel&#39;de tarih i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenin. Burada \u00f6rnekler ve \u00f6rnek dosyalar verdik.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-excel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel tarih i\u0307\u015flevleri"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2108"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2108\/revisions"}],"predecessor-version":[{"id":2370,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2108\/revisions\/2370"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}