{"id":11,"date":"2023-05-09T20:09:00","date_gmt":"2023-05-09T17:09:00","guid":{"rendered":"https:\/\/global.tab-tv.com\/tr\/?p=11"},"modified":"2023-05-10T00:22:11","modified_gmt":"2023-05-09T21:22:11","slug":"microsoft-excelde-bugunun-tarihi-nasil-eklenir","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/tr\/microsoft-excelde-bugunun-tarihi-nasil-eklenir\/","title":{"rendered":"Excel&#8217;de bug\u00fcn\u00fcn tarihi nas\u0131l eklenir"},"content":{"rendered":"\n<p>\u00d6nemli tarihleri takip etmesi gereken bir Excel kullan\u0131c\u0131s\u0131 m\u0131s\u0131n\u0131z? S\u0131k s\u0131k ge\u00e7erli tarihi elle yaz\u0131yor, ancak daha sonra g\u00fcncellenmesi gerekti\u011fini mi fark ediyorsunuz? Excel elektronik tablolar\u0131n\u0131za bug\u00fcn\u00fcn tarihini eklemek i\u00e7in daha etkili bir yol mu ar\u0131yorsunuz? E\u011fer \u00f6yleyse, \u015fansl\u0131s\u0131n\u0131z.<\/p>\n\n\n\n<p>Excel&#8217;de bug\u00fcn\u00fcn tarihini eklemek i\u00e7in basit manuel giri\u015flerden daha geli\u015fmi\u015f VBA makrolar\u0131na kadar \u00e7e\u015fitli y\u00f6ntemler kullanabilirsiniz. \u0130htiya\u00e7lar\u0131n\u0131za ba\u011fl\u0131 olarak statik veya dinamik bir tarih de\u011feri se\u00e7ebilirsiniz. Ba\u015fka bir deyi\u015fle, tarihin g\u00fcncellenip g\u00fcncellenmeyece\u011fi.<\/p>\n\n\n\n<p>\u015e\u00f6yle i\u015fliyor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Excel&#8217;de statik bir tarih nas\u0131l eklenir<\/strong><\/h2>\n\n\n\n<p>Tarihi manuel olarak eklemenin daha kolay oldu\u011funu d\u00fc\u015f\u00fcnebilirsiniz. Bu, tarihi girmek istedi\u011finiz h\u00fccreyi se\u00e7ebilece\u011finiz ve ard\u0131ndan bug\u00fcn\u00fcn tarihini tercih etti\u011finiz bi\u00e7imde yazabilece\u011finiz anlam\u0131na gelir. \u00d6rne\u011fin, tarihi GG\/AA\/YYYY bi\u00e7iminde girmek istiyorsan\u0131z h\u00fccreye &#8220;13\/04\/2023&#8221; yazabilirsiniz.<\/p>\n\n\n\n<p>Ancak, k\u0131sayolu kullanarak bug\u00fcn\u00fcn tarihini eklemek daha da h\u0131zl\u0131d\u0131r. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tarihi girmek istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li>\n\n\n\n<li>Ard\u0131ndan <strong>Ctrl + ; <\/strong>(noktal\u0131 virg\u00fcl) tu\u015flar\u0131na bas\u0131n.<\/li>\n\n\n\n<li>Bu, h\u00fccreye otomatik olarak bug\u00fcn\u00fcn tarihini girecektir.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-2444\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-1.webp 816w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-1-300x268.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-1-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ge\u00e7erli saati eklemek i\u00e7in <strong>Ctrl + Shift + ; <\/strong>(noktal\u0131 virg\u00fcl) tu\u015flar\u0131na bas\u0131n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-2443\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-2.webp 816w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-2-300x268.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-2-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p>Ayr\u0131ca, ge\u00e7erli tarih ve saati ayn\u0131 h\u00fccreye ayn\u0131 anda ekleyebilirsiniz. \u0130\u015fte nas\u0131l yap\u0131laca\u011f\u0131:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gerekli h\u00fccreyi se\u00e7in ve <strong>Ctrl + ; <\/strong>(noktal\u0131 virg\u00fcl) tu\u015flar\u0131na bas\u0131n.<\/li>\n\n\n\n<li>Bundan sonra, bu h\u00fccrede kal\u0131n ve <strong>Bo\u015fluk tu\u015funa <\/strong>bas\u0131n.<\/li>\n\n\n\n<li>Son olarak, <strong>Ctrl + Shift + ; <\/strong>(noktal\u0131 virg\u00fcl) tu\u015flar\u0131na bas\u0131n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-3.webp\" alt=\"\" class=\"wp-image-2442\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-3.webp 816w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-3-300x268.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-add-a-static-date-in-Excel-3-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p>Tarihi yaln\u0131zca ara s\u0131ra eklemeniz gerekiyorsa k\u0131sayol iyi bir se\u00e7enektir, ancak bunu s\u0131k s\u0131k yapman\u0131z gerekiyorsa, di\u011fer y\u00f6ntemlerden birini d\u00fc\u015f\u00fcnmek isteyebilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Excel&#8217;de bug\u00fcn\u00fcn tarihini eklemek i\u00e7in BUG\u00dcN() i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/strong><\/h2>\n\n\n\n<p>BUG\u00dcN() i\u015flevi, Excel&#8217;de ge\u00e7erli tarihi d\u00f6nd\u00fcren yerle\u015fik bir i\u015flevdir. Dosyay\u0131 ne zaman a\u00e7arsan\u0131z a\u00e7\u0131n her zaman ge\u00e7erli tarihi d\u00f6nd\u00fcrece\u011fi i\u00e7in tarihlerle \u00e7al\u0131\u015f\u0131rken kullan\u0131\u015fl\u0131d\u0131r. \u0130\u015flevin s\u00f6zdizimi basittir: =TODAY(). Bu i\u015flevi, ge\u00e7erli tarihi g\u00f6r\u00fcnt\u00fclemeniz gereken herhangi bir h\u00fccrede kullanabilirsiniz.<\/p>\n\n\n\n<p>\u0130\u015fte nas\u0131l kullan\u0131laca\u011f\u0131:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bug\u00fcn\u00fcn tarihini g\u00f6r\u00fcnt\u00fclemek istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li>\n\n\n\n<li>Ard\u0131ndan <strong>&#8220;=TODAY()&#8221; <\/strong>yaz\u0131n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-2441\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1.webp 816w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1-300x268.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p>Bu, h\u00fccrede bug\u00fcn\u00fcn tarihini g\u00f6r\u00fcnt\u00fcler ve tarih her g\u00fcn otomatik olarak g\u00fcncellenir.<\/p>\n\n\n\n<p>Ayr\u0131ca NOW() i\u015flevi de vard\u0131r. Bir Excel elektronik tablosuna hem ge\u00e7erli tarihi hem de saati ekler. Form\u00fcl\u00fcn s\u00f6zdizimi basittir: ge\u00e7erli tarih ve saati g\u00f6r\u00fcnt\u00fclemek istedi\u011finiz h\u00fccreye =NOW() girin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"719\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-2440\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2.webp 806w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2-300x268.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2-768x685.webp 768w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/figure>\n\n\n\n<p>Bu, TODAY() i\u015flevine benzer \u015fekilde \u00e7al\u0131\u015f\u0131r. Excel dosyas\u0131n\u0131 her a\u00e7t\u0131\u011f\u0131n\u0131zda otomatik olarak g\u00fcncellenir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Excel&#8217;de bug\u00fcn\u00fcn tarihini eklemek i\u00e7in VBA Makrosu nas\u0131l kullan\u0131l\u0131r<\/strong><\/h2>\n\n\n\n<p>Excel&#8217;de bug\u00fcn\u00fcn tarihini eklemeyi otomatikle\u015ftirmek i\u00e7in bir VBA makrosu kullanabilirsiniz. Bir makro olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6nergeleri izleyin:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Geli\u015ftirici <\/strong>sekmesine t\u0131klay\u0131n ve <strong>Visual Basic D\u00fczenleyicisini <\/strong>a\u00e7\u0131n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"815\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-2439\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1.webp 940w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1-300x260.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1-768x666.webp 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ard\u0131ndan <strong>Ekle&#8217;<\/strong>ye t\u0131klay\u0131n ve <strong>Mod\u00fcl&#8217;\u00fc <\/strong>se\u00e7in.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"698\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-2438\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2.webp 977w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-300x214.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-768x549.webp 768w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-100x70.webp 100w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bundan sonra, a\u015fa\u011f\u0131daki kodu girin:<\/li>\n<\/ul>\n\n\n\n<p>Sub InsertTodayDate()<\/p>\n\n\n\n<p>ActiveCell.Value = Tarih<\/p>\n\n\n\n<p>End Sub<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"706\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3.webp\" alt=\"\" class=\"wp-image-2437\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3.webp 984w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3-300x215.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3-768x551.webp 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Makroyu kullanmak i\u00e7in dosyay\u0131 makro \u00f6zellikli bir \u00e7al\u0131\u015fma kitab\u0131 olarak kaydedin.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"949\" height=\"819\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4.webp\" alt=\"\" class=\"wp-image-2436\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4.webp 949w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4-300x259.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4-768x663.webp 768w\" sizes=\"auto, (max-width: 949px) 100vw, 949px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ard\u0131ndan, dosyay\u0131 a\u00e7\u0131n, tekrar <strong>Geli\u015ftirici <\/strong>sekmesine gidin ve <strong>Makrolar<\/strong>&#8216;a t\u0131klay\u0131n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"943\" height=\"814\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5.webp\" alt=\"\" class=\"wp-image-2435\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5.webp 943w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5-300x259.webp 300w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5-768x663.webp 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Son olarak, olu\u015fturulan makroyu se\u00e7in ve <strong>\u00c7al\u0131\u015ft\u0131r&#8217;a <\/strong>t\u0131klay\u0131n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"391\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6.webp\" alt=\"\" class=\"wp-image-2434\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6.webp 400w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6-300x293.webp 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure>\n\n\n\n<p>Bu makro, etkin h\u00fccreye bug\u00fcn\u00fcn tarihini ekler.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Excel&#8217;de tarih bi\u00e7imi nas\u0131l de\u011fi\u015ftirilir<\/strong><\/h2>\n\n\n\n<p>Excel&#8217;de tarih bi\u00e7imini de\u011fi\u015ftirmek, tarihleri gereken bi\u00e7imde g\u00f6r\u00fcnt\u00fclemenize yard\u0131mc\u0131 olabilecek basit bir i\u015flemdir. \u0130\u015fte nas\u0131l yap\u0131laca\u011f\u0131:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bi\u00e7imlendirmek istedi\u011finiz tarihleri i\u00e7eren h\u00fccreyi veya h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li>\n\n\n\n<li>Se\u00e7ili h\u00fccre(ler)e sa\u011f t\u0131klay\u0131n ve men\u00fcden <strong>H\u00fccreleri Bi\u00e7imlendir&#8217;i <\/strong>se\u00e7in.<\/li>\n\n\n\n<li><strong>Kategori <\/strong>listesinden <strong>Tarih <\/strong>\u00f6\u011fesini se\u00e7in.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"512\" src=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-change-the-date-format-in-Excel-1.webp\" alt=\"\" class=\"wp-image-2432\" srcset=\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-change-the-date-format-in-Excel-1.webp 560w, https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/05\/How-to-change-the-date-format-in-Excel-1-300x274.webp 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>T\u00fcr <\/strong>listesinden istedi\u011finiz tarih bi\u00e7imini se\u00e7in.<\/li>\n\n\n\n<li>Excel, <strong>mm\/dd\/yyyy <\/strong>veya <strong>dd-mmm-yy <\/strong>gibi \u00f6nceden tan\u0131mlanm\u0131\u015f birka\u00e7 tarih bi\u00e7imi sa\u011flar. Ancak <strong>T\u00fcr <\/strong>alan\u0131na girerek kendi \u00f6zel bi\u00e7iminizi de olu\u015fturabilirsiniz.<\/li>\n\n\n\n<li>Yeni bi\u00e7imi se\u00e7ili h\u00fccre(ler)e uygulamak i\u00e7in <strong>Tamam&#8217;a <\/strong>t\u0131klay\u0131n.<\/li>\n<\/ul>\n\n\n\n<p>Tarih bi\u00e7imini de\u011fi\u015ftirdi\u011finizde, Excel tarihlerinizi se\u00e7ti\u011finiz yeni bi\u00e7imde g\u00f6r\u00fcnt\u00fcleyecektir. Bu, \u00f6zellikle farkl\u0131 tarih bi\u00e7imleriyle \u00e7al\u0131\u015fan ba\u015fkalar\u0131yla payla\u015f\u0131yorsan\u0131z, elektronik tablolar\u0131n\u0131z\u0131 daha okunabilir ve daha kolay anla\u015f\u0131l\u0131r hale getirmeye yard\u0131mc\u0131 olabilir.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00d6nemli tarihleri takip etmesi gereken bir Excel kullan\u0131c\u0131s\u0131 m\u0131s\u0131n\u0131z? S\u0131k s\u0131k ge\u00e7erli tarihi elle yaz\u0131yor, ancak daha sonra g\u00fcncellenmesi gerekti\u011fini mi fark ediyorsunuz? Excel elektronik tablolar\u0131n\u0131za bug\u00fcn\u00fcn tarihini eklemek i\u00e7in daha etkili bir yol mu ar\u0131yorsunuz? E\u011fer \u00f6yleyse, \u015fansl\u0131s\u0131n\u0131z. Excel&#8217;de bug\u00fcn\u00fcn tarihini eklemek i\u00e7in basit manuel giri\u015flerden daha geli\u015fmi\u015f VBA makrolar\u0131na kadar \u00e7e\u015fitli y\u00f6ntemler kullanabilirsiniz. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2445,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[8],"class_list":{"0":"post-11","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-guides","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":3,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":2446,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/posts\/11\/revisions\/2446"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/media\/2445"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/tr\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}