{"id":3696,"date":"2016-07-05T10:31:26","date_gmt":"2016-07-05T10:31:26","guid":{"rendered":"http:\/\/educationwp.thimpress.com\/educationwp-2\/?p=3696"},"modified":"2016-07-23T11:20:58","modified_gmt":"2016-07-23T11:20:58","slug":"why-you-should-read-every-day","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/why-you-should-read-every-day\/","title":{"rendered":"Count Number of Workdays in a given period"},"content":{"rendered":"<p>If we want to count the number of working days in a given period excluding weekly off (optional) and any other holidays (optional), the best way to do it in Excel is through using NETWORKDAYS.INTL. Most of us usually apply NETWORKDAYS function to count the number of working days in a given period, but this function by default consider a weekend of Saturday and Sunday. What if we want to calculate the total number of working days of a company which has only one weekly off i.e. Sunday. This is where NETWORKDAYS.INTL comes into the picture.<\/p>\n<p>Let\u2019s see how to use it with an example\u2026.<\/p>\n<p>Syntax of this formula is:<\/p>\n<p>NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Start_date and end_date<\/strong> The dates for which the difference is to be computed. The start_date can be earlier than, the same as, or later than the end_date.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Weekend Optional<\/strong>. Indicates the days of the week that are weekend days and are not included in the number of whole working days between start_date and end_date. Weekend is a weekend number or string that specifies when weekends occur.<\/li>\n<\/ul>\n<p>Weekend number values indicate the following weekend days:<\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Weekend number<\/strong><\/td>\n<td><strong>Weekend days<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1 or omitted<\/td>\n<td>Saturday, Sunday<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Sunday, Monday<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Monday, Tuesday<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Tuesday, Wednesday<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Wednesday, Thursday<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Thursday, Friday<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Friday, Saturday<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>Sunday only<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Monday only<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>Tuesday only<\/td>\n<\/tr>\n<tr>\n<td>14<\/td>\n<td>Wednesday only<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>Thursday only<\/td>\n<\/tr>\n<tr>\n<td>16<\/td>\n<td>Friday only<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>Saturday only<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday. 1 represents a <strong><em>non-workday<\/em><\/strong> and 0 represents a <strong><em>workday<\/em><\/strong>. Only the characters 1 and 0 are permitted in the string.<\/p>\n<ul>\n<li><strong>Holidays<\/strong> An optional set of one or more dates that are to be excluded from the working day calendar. holidays shall be a range of cells that contain the dates, or an array constant of the serial values that represent those dates. The ordering of dates or serial<\/li>\n<\/ul>\n<p>values in holidays can be arbitrary.<\/p>\n<p>&nbsp;<\/p>\n<p>Just take a look at the below screenshot, these are few examples of how to use this formula.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5943 size-full\" src=\"http:\/\/test.nurturetechacademy.in\/wp-content\/uploads\/2016\/01\/1.jpg\" alt=\"1\" width=\"727\" height=\"179\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2016\/01\/1.jpg 727w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2016\/01\/1-600x148.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2016\/01\/1-300x74.jpg 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Download sample workbook <a href=\"https:\/\/www.dropbox.com\/s\/uie60y8mkrbg96h\/Count%20Number%20of%20Workdays%20in%20a%20given%20period.xlsx?dl=0\">here<\/a>\u2026<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3696\" class=\"pvc_stats all  \" data-element-id=\"3696\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>If we want to count the number of working days in a given period excluding weekly off (optional) and any other holidays (optional), the best way to do it in Excel is through using NETWORKDAYS.INTL. Most of us usually apply <\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3696\" class=\"pvc_stats all  \" data-element-id=\"3696\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":6070,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[57,59,58,60,61],"class_list":["post-3696","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-excel","tag-formulas","tag-functions","tag-networkdays","tag-networkdays-intl"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/3696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=3696"}],"version-history":[{"count":3,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/3696\/revisions"}],"predecessor-version":[{"id":6028,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/3696\/revisions\/6028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/6070"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=3696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=3696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=3696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}