{"id":512,"date":"2015-11-03T17:24:00","date_gmt":"2015-11-03T17:24:00","guid":{"rendered":"http:\/\/xlfxs.com\/?p=512"},"modified":"2015-11-03T17:24:00","modified_gmt":"2015-11-03T17:24:00","slug":"workdays-across-months","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=512","title":{"rendered":"Workdays &#8211; Across months"},"content":{"rendered":"<p><span style=\"font-size: small;\">Get total number of days per month<br \/>\nThis was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the months in the list for a given Start and End dates<\/span><\/p>\n<p><span style=\"font-size: small;\">If Range of dates are across multiple years, user can copy columns C, D, E and F to fill those years<\/span><\/p>\n<p><span style=\"font-size: small;\">The months for the list are automatically populated starting from Jan of the year of the start date<br \/>\n<\/span><\/p>\n<p>The main formula in F7 should be:<\/p>\n<p><!--more--><\/p>\n<pre>=IF(OR($D$2&gt;E7,$D$3&lt;D7),\"\",\nNETWORKDAYS(IF(D7&gt;$D$2,D7,$D$2),IF(E7&lt;$D$3,E7,$D$3)))<\/pre>\n<div id='gallery-1' class='gallery galleryid-512 gallery-columns-3 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon portrait'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/workdays-multimonths3-2.png'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/workdays-multimonths3-2-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/workdays-multimonths2-2.png'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/workdays-multimonths2-2-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/workdays-multimonths1-2.png'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/workdays-multimonths1-2-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n<p>&nbsp;<\/p>\n<div class=\"row\">\n<div class=\"col-lg-6 col-md-6 col-sm-6 text-right\"><a class=\"btn btn-primary btn-lg\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2015\/11\/Workdays-Multi-months.xlsx\"><i class=\"fa fa-download\"><\/i> Download spreadsheet<\/a><\/div>\n<div class=\"col-lg-6 col-md-6 col-sm-6\"><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO18tLzDW8dCro6ZNhng\"><i class=\"fa fa-cloud\"><\/i> Excel Online version<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Get total number of days per month This was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the months in the list for a given Start and End dates If Range of dates are across multiple years, user can copy columns C, D,&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=512\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Workdays &#8211; Across months&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":514,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76,23,3,80,42,45,6,65],"tags":[],"class_list":["post-512","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-date","category-date-and-time","category-formulas","category-if","category-month","category-networkdays","category-standard_functions","category-year"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=512"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/512\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/514"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}