{"id":1657,"date":"2020-01-04T07:17:35","date_gmt":"2020-01-04T07:17:35","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=1657"},"modified":"2021-04-07T17:32:12","modified_gmt":"2021-04-07T17:32:12","slug":"zile-libere-2021-sarbatori-legale-2020-calculate-cu-ajutorul-excel-zile-lucratoare-2021","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/zile-libere-2021-sarbatori-legale-2020-calculate-cu-ajutorul-excel-zile-lucratoare-2021\/","title":{"rendered":"Zile libere 2020 calculate cu ajutorul Excel\/ zile lucratoare 2021"},"content":{"rendered":"<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; 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]<\/p>\n<h3 style=\"text-align: left;\"><strong>NETWORKDAYS,WEEKDAY &amp; CHOOSE<\/strong><\/h3>\n<h4 style=\"text-align: left;\">Windows shortcut: n\/a<\/h4>\n<p style=\"text-align: left;\"><strong>Networkdays<\/strong> (start_date, end_date, [Holidays]) functie care returneaza numarul de zile lucratoare<\/p>\n<p style=\"text-align: left;\"><strong>Weekday<\/strong> (data,return_type) &#8211; returneaza numarul de zile din saptamana.<\/p>\n<p style=\"text-align: left;\"><strong>Choose<\/strong> (index_num, Value1, Value2,&#8230;)- returneaza o valoarea definita de noi in functie de index<\/p>\n<h4 style=\"text-align: left;\">Structura functiei<\/h4>\n<p>[\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;1647&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221; qode_css_animation=&#8221;&#8221;][vc_column_text]<\/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 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-0 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-tab-113\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Cum calculam numarul de zile lucratoare dintr-un an tinand cont de zilele libere legale din anul respectiv cu ajutorul Microsoft Excel?<\/h1>\n<p>Vom lua anul in curs, adica 2020 iar cerinta noastra va suna de felul urmator:<\/p>\n<p>Sa se calculeze numarul de zile lucratoare ale anului 2020 folosind Microsoft Excel. Dupa cum stim zilele lucratoare ale unui an reprezinta diferenta dintre totalul zilelor anului respectiv si zilele nelucratoare (zile de weekend + zile libere legale valabile in anul pentru care facem calculele).<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/yM1A2hv9u58\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h2>Numar de zile lucratoare in 2020.<\/h2>\n<p>Microsoft Excel detine in biblioteca proprie de functii, functia <strong>NETWORKDAYS<\/strong> cu ajutorul careia vom returna numarul de zile lucratoare dintre 2 date.<\/p>\n<h3>1. Setam intervalul pentru care vom facem calculele (Data de start si Data de final)<\/h3>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-1648 size-full alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/1.-700px-jpg.jpg\" alt=\"\" width=\"700\" height=\"83\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/1.-700px-jpg.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/1.-700px-jpg-300x36.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<h3>2. Definim zona de zile libere legale aferente anului 2020.<\/h3>\n<p>Insertia datelor se face manual de catre Dvs, detalii mai jos:<br \/>\n<img decoding=\"async\" class=\"wp-image-1909 size-full alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/2.-700-px.png\" alt=\"\" width=\"700\" height=\"468\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/2.-700-px.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/2.-700-px-300x201.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>(Sper ca le-am trecut pe toate!)\u00a0 \ud83d\ude42<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/JHDz2k1cJgk\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h3>3. In momentul de fata avem toate datele necesare pentru a efectua calcule, data de start, data de final si libere legale definite.<\/h3>\n<h2>Prin urmare <a href=\"https:\/\/youtu.be\/JHDz2k1cJgk\">functia <strong>NETWORKDAYS<\/strong> <\/a>va arata in felul urmator:<\/h2>\n<p><strong>=NETWORKDAYS(B2,B3,B7:B21)<\/strong>, functie ce ne va afisa un total de 251 zile lucratoare pentru anul 2020.<br \/>\n<img decoding=\"async\" class=\"wp-image-1651 size-full alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/3.2.700-px.jpg\" alt=\"\" width=\"700\" height=\"603\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/3.2.700-px.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/3.2.700-px-300x258.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><br \/>\nVom complica putin exercitiul nostru si vom mai introduce cateva functii Excel, una dintre ele este functia <strong>WEEKDAY<\/strong><br \/>\ncare ne va returna numarul zilei din saptamana (valoare numerica).<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1243 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/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\" \/><br \/>\n<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 zi din saptamana Luni, ultima zi din saptamana Duminica).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1652 size-full alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/4.700-px.jpg\" alt=\"\" width=\"700\" height=\"490\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/4.700-px.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/4.700-px-300x210.jpg 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 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:\/\/sky-it.ro\/clone\/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=\"wp-image-1653 size-full alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/5.-700px.jpg\" alt=\"\" width=\"700\" height=\"404\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/5.-700px.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/5.-700px-300x173.jpg 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/5.-700px-345x198.jpg 345w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<h2>Raportul final al proiectului nostru va arata de forma:<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1655 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/final700px.jpg\" alt=\"\" width=\"700\" height=\"425\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/final700px.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/final700px-300x182.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<h2><em>Observatii:<\/em><\/h2>\n<ol>\n<li>Pentru calculul total al\u00a0<strong>numarului zilelor libere legale<\/strong> am folosit functia <strong>COUNT<\/strong><\/li>\n<li>Penttru calculul <strong>zilelor libere din cursul saptamanii<\/strong>, respectiv al celor din <strong>week-end<\/strong> am folosit functia <strong>COUNTIF<\/strong><\/li>\n<\/ol>\n<p>[\/vc_column_text]<\/div><\/div>[\/vc_column][\/vc_row][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; css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !important;background-color: #ffffff !important;}&#8221;][vc_column]<div class='qode_carousels_holder clearfix'><div class='qode_carousels' data-number-of-visible-items='4'><ul class='slides'><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel1-1.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel3.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel2-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel5.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel4.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel7.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel6.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel9.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel8.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel11.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel10.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel13.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel12.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel15.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel14.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><\/ul><\/div><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<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; 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] NETWORKDAYS,WEEKDAY &amp; CHOOSE 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 zile din saptamana. Choose (index_num, Value1, Value2,&#8230;)- returneaza o valoarea&#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\/1657"}],"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=1657"}],"version-history":[{"count":18,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1657\/revisions"}],"predecessor-version":[{"id":2935,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1657\/revisions\/2935"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1657"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}