{"id":3739,"date":"2023-07-15T20:14:19","date_gmt":"2023-07-15T20:14:19","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-yyyyaaggyi-bugune-donustur\/"},"modified":"2023-07-15T20:14:19","modified_gmt":"2023-07-15T20:14:19","slug":"excel-yyyyaaggyi-bugune-donustur","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-yyyyaaggyi-bugune-donustur\/","title":{"rendered":"Excel: yyyyaagg'nin tarih bi\u00e7imine nas\u0131l d\u00f6n\u00fc\u015ft\u00fcr\u00fclece\u011fi"},"content":{"rendered":"

<\/p>\n

\n

Excel’de YYYYAAGG<\/strong> bi\u00e7imindeki bir tarihi GG\/AA\/YYYY<\/strong> bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =DATE(LEFT( A2,4<\/span> ),MID( A2,5,2<\/span> ),RIGHT( A2,2<\/span> ))\n<\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl, A2<\/strong> h\u00fccresindeki tarih de\u011ferini YYYYAAGG<\/strong> format\u0131ndan GG\/AA\/YYYY<\/strong> format\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/span><\/p>\n
 \u00d6rne\u011fin, bu, 20191030<\/strong> de\u011ferini, okunmas\u0131 daha kolay bir tarih bi\u00e7imi olan 10\/30\/2019<\/strong> bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n
 \u00d6rnek: YYYYAAGG’yi Excel’de Tarih Format\u0131na D\u00f6n\u00fc\u015ft\u00fcrme<\/strong><\/span><\/h2>\n
 Diyelim ki Excel’de \u015fu anda YYYYAAGG format\u0131nda a\u015fa\u011f\u0131daki tarih listesine sahibiz:<\/span> <\/p>\n
\"\"<\/p>\n
 A2<\/strong> h\u00fccresindeki tarih de\u011ferini daha tan\u0131nabilir bir tarih bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in B2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =DATE(LEFT( A2,4<\/span> ),MID( A2,5,2<\/span> ),RIGHT( A2,2<\/span> ))<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyip doldurabiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 A s\u00fctunundaki her tarih de\u011ferinin, B s\u00fctunundaki AA\/GG\/YYYY<\/strong> bi\u00e7iminde bir tarih de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcld\u00fc\u011f\u00fcn\u00fc unutmay\u0131n.<\/span><\/p>\n
 Bonus: Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131r?<\/span><\/strong><\/span><\/h2>\n
 Excel’deki DATE<\/strong> i\u015flevi a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullan\u0131r:<\/span><\/p>\n
 =DATE(year, month, day)<\/strong><\/pre>\n
 Daha sonra MM\/DD\/YYYY<\/strong> format\u0131nda bir tarih d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 Yani DATE(2019, 10, 30)<\/strong> yazarsak Excel 30\/10\/2019<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 \u015eimdi a\u015fa\u011f\u0131daki form\u00fcl\u00fc ne zaman kulland\u0131\u011f\u0131m\u0131z\u0131 d\u00fc\u015f\u00fcn\u00fcn:<\/span><\/p>\n
 =DATE(LEFT( A2,4<\/span> ),MID( A2,5,2<\/span> ),RIGHT( A2,2<\/span> ))<\/strong><\/pre>\n
 Bu form\u00fcl, Excel’e TAR\u0130H<\/strong> i\u015flevine a\u015fa\u011f\u0131daki ba\u011f\u0131ms\u0131z de\u011fi\u015fkenleri sa\u011flamas\u0131n\u0131 s\u00f6yler:<\/span><\/p>\n