{"id":905,"date":"2020-05-28T20:52:24","date_gmt":"2020-05-28T18:52:24","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=905"},"modified":"2024-11-06T00:09:46","modified_gmt":"2024-11-05T22:09:46","slug":"izracunavanje-broja-radnih-dana-izmedu-dva-datuma","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=905","title":{"rendered":"Izra\u010dunavanje broja radnih dana izme\u0111u dva datuma"},"content":{"rendered":"<p>Kada izra\u010dunavate broj dana izme\u0111u dva datuma, mo\u017eete da isklju\u010dite vikende i praznike. Treba vam, na primer, broj radnih dana u novembru. U tome \u0107e vam pomo\u0107i funkcija NETWORKDAYS.<\/p>\n<p>Funkcija NETWORKDAYS izra\u010dunava broj dana izme\u0111u dva datuma izuzimaju\u0107i dane vikenda (subote i nedelje). Kao opciju, mo\u017eete zadati podru\u010dje s datumima praznika da biste i njih isklju\u010dili. Excel nema nikakvog na\u010dina da odredi koji su dani prazni\u010dni, pa tu informaciju morate da upi\u0161ete u podru\u010dje.<\/p>\n<p>Na slici prikazan je radni list na kome smo izra\u010dunavali broj radnih dana. Opseg B12:B20 sadr\u017ei datume praznika. Dve formule u koloni F izra\u010dunavaju broj radnih dana izme\u0111u datuma u kolonama D i E. Formula u \u0107eliji F13 za ovaj primer je:<\/p>\n<p>=NETWORKDAYS(D13,E13,B13:B20)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-906\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/izracunavanjevreme341.jpg\" alt=\"izracunavanjevreme341\" width=\"776\" height=\"477\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/izracunavanjevreme341.jpg 776w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/izracunavanjevreme341-300x184.jpg 300w\" sizes=\"auto, (max-width: 776px) 100vw, 776px\" \/><\/p>\n<p>Ova formula daje rezultat 70, \u0161to zna\u010di da sedmodnevni period, koji je zapo\u010deo 17. februara sadr\u017ei 78 radna dana. Drugim re\u010dima, iz rezultata su isklju\u010deni dani praznika, subota i nedelja.<\/p>\n<p><video controls=\"controls\" width=\"600\" height=\"400\"><source src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/34. Izracunavanje broja dana izmedju dva datuma.mp4\" type=\"video\/mp4\" \/><\/video><\/p>\n<p><strong>Pomeranje datuma samo za radne dane<\/strong><\/p>\n<p>Funkcija WORKDAY predstavlja suprotnost funkciji NETWORKDAYS. Na primer, ako projekat po\u010dinjete 13. maja, a treba vam deset radnih dana da ga zavr\u0161ite, funkcijom WORKDAY mo\u017eete da izra\u010dunate datum kada \u0107ete zavr\u0161iti projekat.<\/p>\n<p>=WORKDAY(&#8220;5\/13\/2016&#8221;,10)<\/p>\n<p>Formula vra\u0107a radni broj datuma koji mora biti formatiran kao datum. Rezultat je 27. maj 2016. (4 dana vikenda su izme\u0111u 13. i 27. maja).<\/p>\n<p><strong>Prikazivanje formatiranih vrednosti u obliku teksta<\/strong><\/p>\n<p>U ve\u017ebi je dat primer spajanja teksta sa formulom u primeru izra\u010dunavanja maksimalne vrednosti u nekom odre\u0111enom podru\u010dju:<\/p>\n<p>=&#8221;Najve\u0107a vrednost u koloni\u00a0 C iznosi &#8221; &amp;MAX(C:C)<\/p>\n<p>Evo jo\u0161 jednog primera kori\u0161\u0107enja funkcije NOW (njen rezultat su teku\u0107i datum i vreme). Funkcija TEXT prikazuje datum i vreme u pogodnom formatu.<\/p>\n<p>=&#8221;Izve\u0161taj od\u0161tampan dana: &#8220;&amp;TEXT(NOW(),&#8221;dd.mm.yyyy u hh:mm&#8221;)<\/p>\n<p>Rezultat formule mogao bi biti slede\u0107i: Izve\u0161taj od\u0161tampan dana: 17.02.2016. u 23:10.<\/p>\n<p><strong><a href=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/34. Izracunavanje broja dana izmedju dva datuma.xlsx\">Ve\u017eba<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"Kada izra\u010dunavate broj dana izme\u0111u dva datuma, mo\u017eete da isklju\u010dite vikende i<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=905\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":911,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-905","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=905"}],"version-history":[{"count":1,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/905\/revisions"}],"predecessor-version":[{"id":1227,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/905\/revisions\/1227"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/911"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}