{"id":1465,"date":"2019-12-09T10:35:34","date_gmt":"2019-12-09T10:35:34","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=1465"},"modified":"2021-04-22T10:50:12","modified_gmt":"2021-04-22T10:50:12","slug":"numar-de-zile-lucratoare-in-2019-functia-networkdays","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/numar-de-zile-lucratoare-in-2019-functia-networkdays\/","title":{"rendered":"Numar de zile lucratoare in 2019- Functia NETWORKDAYS"},"content":{"rendered":"<h3 style=\"text-align: left;\"><strong>NETWORKDAYS,WEEKDAY &amp; CHOOSE<\/strong><\/h3>\n<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221;<\/p>\n<p>angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221;<\/p>\n<p>z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text]<\/p>\n<h4 style=\"text-align: left;\">Windows shortcut: n\/a<\/h4>\n<p style=\"text-align: left;\"><strong>Networkdays<\/strong> (start_date, end_date,<\/p>\n<p>[Holidays]) functie care returneaza numarul de zile lucratoare<\/p>\n<p style=\"text-align: left;\"><strong>Weekday<\/strong> (data,return_type) &#8211; returneaza<\/p>\n<p>numarul de ziledin saptamana.<\/p>\n<p style=\"text-align: left;\"><strong>Choose<\/strong> (index_num, Value1, Value2,&#8230;)-<\/p>\n<p>returneaza o valoarea definita de noi in functie de index<\/p>\n<h4 style=\"text-align: left;\">Structura functiei<\/h4>\n<p><iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/JHDz2k1cJgk\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: left;\">Observatie: Formula NETWORKDAYS are urmatoarele argumente:<\/p>\n<p><strong>Start_date:<\/strong> data de start<br \/>\n<strong>End_date:<\/strong> data de final<br \/>\n<strong>Holidays:<\/strong> argument optional (se refera la sarbatorile\/zilele libere ce se<\/p>\n<p>regasesc in intervalul nostru de interes\u2014intre data de inceput si data de final).<\/p>\n<h5><\/h5>\n<h5 style=\"text-align: left;\">&#8222;Learn today for tomorrow!&#8221;<\/h5>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;3\/4&#8243;]<div class=\"qode-advanced-tabs qode-advanced-tabs qode-advanced-horizontal-tab clearfix qode-advanced-tab-without-icon qode-advanced-tabs-column-1 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-exemplu-practic\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tExemplu practic\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t<\/ul>\n\t<\/p>\n<div class=\"qode-advanced-tab-container\" id=\"tab-exemplu-practic-550\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]Cum calculam numarul de zile<\/p>\n<p>lucratoare dintr-un an tinand cont de zilele libere legale din anul respectiv cu ajutorul<\/p>\n<p>Microsoft Excel?<br \/>\nVom lua anul in curs, adica 2019 iar cerinta noastra va suna de felul urmator:<\/p>\n<p>Sa se calculeze numarul de zile lucratoare ale anului 2019 folosind Microsoft Excel. Dupa<\/p>\n<p>cum stim zilele lucratoareale unui an reprezinta diferenta dintre totalul zilelor anului<\/p>\n<p>respectiv si zilele nelucratoare (zile de weekend + zile libere legale valabile in anul<\/p>\n<p>pentru care facem calculele).<\/p>\n<h4>Numar de zile lucratoare in 2019.<\/h4>\n<p>Microsoft Excel detine in biblioteca proprie de formule, formula Networkdays cu ajutorul<\/p>\n<p>careia vom returna numarul de zile lucratoare dintre 2 date.<\/p>\n<p>1. Setam intervalul pentru care vom facem calculele (Data de start si data de final)<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-1240 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/2.png\" alt=\"\" width=\"700\" height=\"98\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/2.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/2-300x42.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>2. Definim zona de zile libere legale aferente anului 2019.<br \/>\nInsertia datelor se face manual de catre Dvs, detalii mai jos:<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-1241 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/3.png\" alt=\"\" width=\"700\" height=\"429\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/3.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/3-300x184.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>(Sper ca le-am trecut pe toate!):)<\/p>\n<p>3. In momentul de fata avem toate datele necesare pentru a efectua calcule, data de start,<\/p>\n<p>data de final si libere legale definite.<br \/>\nPrin urmare funtia <strong>NETWORKDAYS<\/strong> va arta in felul urmator:<br \/>\n<strong>=NETWORKDAYS(B2,B3,B7:B21)<\/strong>, functie ce ne va afisa un total de 251 zile<\/p>\n<p>lucratoare pentru anul 2019.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-1242 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/4.png\" alt=\"\" width=\"700\" height=\"717\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/4.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/4-293x300.png 293w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Vom complica putin exercitiul nostru si vom mai introduce cateva functii Excel, una dintre<\/p>\n<p>ele este functia <strong>WEEKDAY<\/strong> care ne va returna numarul zilei din saptamana<\/p>\n<p>(valoare numerica).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1243 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/6.png\" alt=\"\" width=\"700\" height=\"268\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/6.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/6-300x115.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p><strong>Serial_number<\/strong> \u2013 ziua format data<\/p>\n<p><strong>Return_type<\/strong> \u2013 vom trece 2, pentru formatul european al saptamanii (prima<\/p>\n<p>zi din saptamana Luni, ultima zi din saptamana Duminica).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1249 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/7.png\" alt=\"\" width=\"700\" height=\"546\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/7.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/7-300x234.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Cumva am vrea sa stim si ce zile din an reprezinta acele date, ne vom folosi de inca o<\/p>\n<p>functie numita:<\/p>\n<p><strong>CHOOSE<\/strong> (Index_nume, Value 1, Value2,\u2026).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1251 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/8.png\" alt=\"\" width=\"700\" height=\"347\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/8.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/8-300x149.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p><strong>Index_num<\/strong>\u2014selectie de la C7:C21<\/p>\n<p><strong>Value\u2026<\/strong>\u2014definim de la tastatura<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1252 alignnone\" src=\"https:\/\/oferta-creare-website- seo.ro\/skyit\/wp-content\/uploads\/2019\/12\/9.png\" alt=\"\" width=\"700\" height=\"472\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/9.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/9-300x202.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>[\/vc_column_text]<\/div><\/div>[\/vc_column][\/vc_row][vc_row<\/p>\n<p>css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221;<\/p>\n<p>angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221;<\/p>\n<p>css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !<\/p>\n<p>important;background-color: #ffffff !important;}&#8221;][vc_column][\/vc_column][\/vc_row]<\/p>\n<div>test<\/div>\n","protected":false},"excerpt":{"rendered":"<p>NETWORKDAYS,WEEKDAY &amp; CHOOSE [vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text] Windows shortcut: n\/a Networkdays (start_date, end_date, [Holidays]) functie care returneaza numarul de zile lucratoare Weekday (data,return_type) &#8211; returneaza numarul de ziledin saptamana. Choose (index_num, Value1, Value2,&#8230;)- returneaza o valoarea definita&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1465"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/comments?post=1465"}],"version-history":[{"count":2,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1465\/revisions"}],"predecessor-version":[{"id":2989,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1465\/revisions\/2989"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1465"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}