{"id":2771,"date":"2023-07-20T18:57:50","date_gmt":"2023-07-20T18:57:50","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-tarihi-sayiya-cevirme\/"},"modified":"2023-07-20T18:57:50","modified_gmt":"2023-07-20T18:57:50","slug":"excel-tarihi-sayiya-cevirme","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-tarihi-sayiya-cevirme\/","title":{"rendered":"Excel'de tarih say\u0131ya nas\u0131l d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcr (3 \u00f6rnek)"},"content":{"rendered":"

<\/p>\n

\n

Bu e\u011fitimde \u00fc\u00e7 farkl\u0131 senaryoda bir tarihin say\u0131ya nas\u0131l d\u00f6n\u00fc\u015ft\u00fcr\u00fclece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n

1.<\/strong> Tarihi say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/span><\/p>\n

2.<\/strong> Birden fazla tarihi say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/span><\/p>\n

3.<\/strong> Tarihi, ba\u015fka bir tarihten bu yana ge\u00e7en g\u00fcn say\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/span><\/p>\n

Hadi gidelim!<\/span><\/p>\n

\u00d6rnek 1: Tarihi say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrme<\/strong><\/span><\/h2>\n

Diyelim ki “02\/10\/2022” tarihini Excel’de bir say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek istiyoruz.<\/span><\/p>\n

Bunu yapmak i\u00e7in Excel’deki TARIH DE\u011eER\u0130<\/strong> i\u015flevini kullanabiliriz:<\/span><\/p>\n

 =DATEVALUE(\"2\/10\/2022\")\n<\/strong><\/pre>\n
 Varsay\u0131lan olarak bu i\u015flev, belirli bir tarih ile 1\/1\/1900<\/strong> aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplar.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu i\u015flevin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n
\"\"<\/p>\n
 Bu bize 02\/10\/2022 ile 1\/1\/1900 aras\u0131nda 44.602<\/strong> g\u00fcn fark oldu\u011funu s\u00f6yl\u00fcyor.<\/span><\/p>\n
 \u00d6rnek 2: Birden \u00c7ok Tarihi Say\u0131lara D\u00f6n\u00fc\u015ft\u00fcrme<\/strong><\/span><\/h2>\n
 Excel’de a\u015fa\u011f\u0131daki tarih listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 Bu tarihlerin her birini bir say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in, tarihleri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulayabilir, ard\u0131ndan Giri\u015f<\/strong> sekmesindeki Say\u0131 Bi\u00e7imi<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcn\u00fc t\u0131klay\u0131p Say\u0131’y\u0131<\/strong> se\u00e7ebiliriz:<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Bu, her tarihi otomatik olarak her tarih ile 1\/1\/1900<\/strong> aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 temsil eden bir say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrecektir:<\/span> <\/p>\n
\"\"<\/p>\n
 \u00d6rnek 3: Tarihi, ba\u015fka bir tarihten bu yana ge\u00e7en g\u00fcn say\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/strong><\/span><\/h2>\n
 Bir tarihi, ba\u015fka bir tarihten bu yana ge\u00e7en g\u00fcn say\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n
 =DATEDIF( B2<\/span> , A2<\/span> , \"d\")\n<\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl, B2<\/strong> h\u00fccresindeki tarih ile A2<\/strong> h\u00fccresindeki tarih aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplar.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc, A s\u00fctunundaki tarihler ile 1\/1\/2022 aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in TAR\u0130HL\u0130 E\u011eER<\/strong> form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 \"\"<\/span><\/p>\n
 B s\u00fctunundaki de\u011ferleri \u015fu \u015fekilde yorumlayabilirsiniz:<\/span><\/p>\n