Syntax<\/h3>\n
NETWORKDAYS(start_date, end_date, [holidays])<\/strong><\/span><\/p>\n <\/p>\n [\/et_pb_text][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”] Automate data transfers beyond Importrange<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us try our hands on this formula. Please consider the snapshot below. We have a sample list of holiday dates from A2 to A6.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-22.png” alt=”NETWORKDAYS Formula: Usage” title_text=”networkdays-formula-usage” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the first example case, the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>and\u00a0<\/span>end_date<\/strong><\/span>\u00a0<\/span>parameters take outputs from two different\u00a0<\/span>DATE()<\/a>\u00a0<\/span>functions, evaluated to 15-Mar-2017 and 15-Apr-2017 respectively. And, we ignored the\u00a0<\/span>holiday\u2019s<\/strong><\/span>\u00a0<\/span>parameter altogether. Therefore, the NETWORKDAYS formula calculates the resulting number of work days falling between the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>and\u00a0<\/span>end_date<\/strong><\/span>. It does so by ignoring the Saturdays and Sundays but does include the start and end dates<\/p>\n The second example is pretty similar. Except, the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>and the\u00a0<\/span>end_date<\/strong><\/span>parameters are references to the cells that has dates. Also, we have given a range reference to the list of holidays for the third parameter. So it counts the net working days after ignoring Saturdays, Sundays, and the list of holidays that fall between the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>and\u00a0<\/span>end_date<\/strong><\/span>.<\/p>\n Unlike the previous two cases, the input values for\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>and\u00a0<\/span>end_date<\/strong><\/span>parameters are absolute numbers for the next two examples. Nevertheless, the formula\u2019s working remains the same.<\/p>\n Let us experiment a little further and input text based date values for the\u00a0<\/span>start_date<\/strong><\/span>and\u00a0start_date<\/strong><\/span>\u00a0<\/span>parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-23.png” alt=”NETWORKDAYS Formula in Google Sheets” title_text=”networksday-formula” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the first example, the formula truncates the decimal values and uses only the integer values and accordingly evaluates the count. Of course, it cannot accept negative numbers, as there is no date interpretation for such values.<\/p>\n From the next two examples, we will see that the NETWORKDAYS formula accepts input date strings in the \u201cdd-mmm-yyyy\u201d and \u201cmm-dd-yyyy\u201d formats. But it will throw up an error with \u201cdd-mm-yyyy\u201d date format strings.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you go! Use the NETWORKDAYS formula in Google Sheets to calculate the number of net working days between two specified dates.<\/p>\n If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog post on the DAYS360 formula in Google Sheets<\/a>.<\/p>\n Alternatively, check out related blog posts below![\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”50458″ theme_builder_area=”post_content”] One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In Google Sheets application, if we need to know the number of net working days between two specified dates, the\u00a0NETWORKDAYS\u00a0formula can be our companion. Syntax NETWORKDAYS(start_date, end_date, [holidays]) start_date\u00a0\u2013 the starting date in the period from which the formula calculates the number of net working days. This date, if not a holiday, is considered for […]<\/p>\n","protected":false},"author":40,"featured_media":4209,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In Google Sheets application, if we need to know the number of net working days between two specified dates, the NETWORKDAYS<\/a> formula can be our companion.\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\nUsage: NETWORKDAYS Formula<\/h3>\n
Cases of interest<\/h5>\n
NETWORKDAYS formula<\/h3>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n<\/p>\nSyntax<\/h3>\nNETWORKDAYS(start_date, end_date, [holidays])<\/strong><\/span>\n
\n \t
Usage: NETWORKDAYS Formula<\/h3>\nLet us try our hands on this formula. Please consider the snapshot below. We have a sample list of holiday dates from A2 to A6.\n\n
![\"NETWORKDAYS](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-22.png\")
\n\nIn the first example case, the start_date<\/strong><\/span> and end_date<\/strong><\/span> parameters take outputs from two different DATE() functions, evaluated to 15-Mar-2017 and 15-Apr-2017 respectively. And, we ignored the holiday's<\/strong><\/span> parameter altogether. Therefore, the NETWORKDAYS formula calculates the resulting number of work days falling between the start_date<\/span><\/strong><\/span> and end_date<\/strong><\/span>. It does so by ignoring the Saturdays and Sundays but does include the start and end dates\n\nThe second example is pretty similar. Except, the start_date<\/strong><\/span> and the end_date<\/strong><\/span> parameters are references to the cells that has dates. Also, we have given a range reference to the list of holidays for the third parameter. So it counts the net working days after ignoring Saturdays, Sundays, and the list of holidays that fall between the start_date<\/strong><\/span> and end_date<\/strong><\/span>.\n\nUnlike the previous two cases, the input values for start_date<\/strong><\/span> and end_date<\/strong><\/span> parameters are absolute numbers for the next two examples. Nevertheless, the formula's working remains the same.\nCases of interest<\/h5>\nLet us experiment a little further and input text based date values for the start_date<\/strong><\/span> and start_date<\/strong><\/span> parameter.\n\n
![\"NETWORKDAYS](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-23.png\")
\n\nIn the first example, the formula truncates the decimal values and uses only the integer values and accordingly evaluates the count. Of course, it cannot accept negative numbers, as there is no date interpretation for such values.\n\nFrom the next two examples, we will see that the NETWORKDAYS formula accepts input date strings in the \"dd-mmm-yyyy\" and \"mm-dd-yyyy\" formats. But it will throw up an error with \"dd-mm-yyyy\" date format strings.\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-4136","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/4136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=4136"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/4136\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/4209"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=4136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=4136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=4136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}