Bazen bir mali y\u0131l, bir takvim y\u0131l\u0131na kar\u015f\u0131l\u0131k gelen Ocak ay\u0131n\u0131n ba\u015f\u0131ndan Aral\u0131k ay\u0131n\u0131n sonuna kadar \u00f6l\u00e7\u00fcl\u00fcr.<\/span><\/p>\n Ancak \u015firketler bazen mali y\u0131l olarak 12 aydan farkl\u0131 bir d\u00f6nem kullan\u0131rlar.<\/span><\/p>\n \u00d6rne\u011fin, bazen bir mali y\u0131l Nisan ay\u0131n\u0131n ba\u015f\u0131ndan Mart ay\u0131n\u0131n sonuna kadar uzan\u0131r.<\/span><\/p>\n Excel’deki bir tarihten mali y\u0131l\u0131 \u00e7\u0131karmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, mali y\u0131l\u0131 A2<\/strong> h\u00fccresindeki tarihten \u00e7\u0131kar\u0131r ve mali y\u0131l\u0131n Mart ay\u0131n\u0131n son g\u00fcn\u00fcnde (y\u0131l\u0131n \u00fc\u00e7\u00fcnc\u00fc ay\u0131) bitti\u011fini varsayar.<\/span><\/span><\/p>\n Farkl\u0131 bir biti\u015f ay\u0131 kullanmak i\u00e7in form\u00fcldeki 3’\u00fc<\/strong> farkl\u0131 bir de\u011ferle de\u011fi\u015ftirmeniz yeterlidir.<\/span><\/p>\n \u00d6rne\u011fin, mali y\u0131l Ekim ay\u0131n\u0131n son g\u00fcn\u00fcnde bitiyorsa y\u0131l\u0131n 10. ay\u0131 oldu\u011fundan bunun yerine 10<\/strong> kullan\u0131n.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n Excel’de a\u015fa\u011f\u0131daki tarih s\u00fctununun bulundu\u011funu varsayal\u0131m:<\/span> <\/p>\n Bu i\u015fletmenin Nisan ay\u0131n\u0131n ilk g\u00fcn\u00fc ba\u015flay\u0131p Mart ay\u0131n\u0131n son g\u00fcn\u00fc biten bir mali y\u0131l kulland\u0131\u011f\u0131n\u0131 varsayal\u0131m.<\/span><\/p>\n A2<\/strong> h\u00fccresindeki tarihin mali y\u0131l\u0131n\u0131 almak i\u00e7in B2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n B s\u00fctunu, A s\u00fctunundaki her tarihin mali y\u0131l\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n 1 Nisan 2023’ten \u00f6nceki her tarihin mali y\u0131l\u0131 2022’dir; 1 Nisan 2023’te veya sonras\u0131nda ba\u015flayan her tarihin mali y\u0131l\u0131 ise 2023’t\u00fcr.<\/span><\/p>\n Mali y\u0131l\u0131 elde etmek i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fc hat\u0131rlay\u0131n:<\/span><\/p>\n Bu form\u00fcl\u00fcn i\u015fleyi\u015fi \u015f\u00f6yle:<\/span><\/p>\n MONTH<\/strong> i\u015flevi bir tarihten ay\u0131 \u00e7\u0131kar\u0131r.<\/span><\/p>\n Ay 3’ten b\u00fcy\u00fckse (yani Mart’tan sonra), A2<\/strong> h\u00fccresindeki y\u0131l d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/span><\/p>\n Aksi takdirde, ay 3’e e\u015fit veya 3’ten k\u00fc\u00e7\u00fckse A2<\/strong> h\u00fccresindeki y\u0131ldan \u00f6nceki y\u0131l d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/span><\/p>\n \u00d6rne\u011fin, A2<\/strong> h\u00fccresi 1\/1\/2023 tarihine sahiptir. Bu tarihin ay\u0131 3’ten k\u00fc\u00e7\u00fck oldu\u011fundan 2022 y\u0131l\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de saat olmadan tarihler nas\u0131l kar\u015f\u0131la\u015ft\u0131r\u0131l\u0131r<\/a> Mali y\u0131l, i\u015fletmeler taraf\u0131ndan muhasebe amac\u0131yla kullan\u0131lan 12 ayl\u0131k bir d\u00f6nemdir. Bazen bir mali y\u0131l, bir takvim y\u0131l\u0131na kar\u015f\u0131l\u0131k gelen Ocak ay\u0131n\u0131n ba\u015f\u0131ndan Aral\u0131k ay\u0131n\u0131n sonuna kadar \u00f6l\u00e7\u00fcl\u00fcr. Ancak \u015firketler bazen mali y\u0131l olarak 12 aydan farkl\u0131 bir d\u00f6nem kullan\u0131rlar. \u00d6rne\u011fin, bazen bir mali y\u0131l Nisan ay\u0131n\u0131n ba\u015f\u0131ndan Mart ay\u0131n\u0131n sonuna kadar uzan\u0131r. Excel’deki bir […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4670","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =IF(MONTH( A2<\/span> )>3, YEAR( A2<\/span> ), YEAR( A2<\/span> )-1)<\/strong>\n<\/pre>\n \u00d6rnek: Excel’deki Tarihten Mali Y\u0131l\u0131 Alma<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiscal1.png\")
<\/p>\n =IF(MONTH( A2<\/span> )>3, YEAR( A2<\/span> ), YEAR( A2<\/span> )-1)<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiscal2.png\")
<\/p>\n Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/span><\/h2>\n
=IF(MONTH( A2<\/span> )>3, YEAR( A2<\/span> ), YEAR( A2<\/span> )-1)<\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de bir tarih aral\u0131\u011f\u0131yla SUMIFS nas\u0131l kullan\u0131l\u0131r?<\/a>
Excel’de tarihleri aya g\u00f6re filtreleme<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"