{"id":34007,"date":"2024-01-12T01:19:04","date_gmt":"2024-01-12T00:19:04","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=34007"},"modified":"2024-03-22T20:18:17","modified_gmt":"2024-03-22T19:18:17","slug":"calculate-workdays-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-workdays-in-excel\/","title":{"rendered":"How to Calculate Workdays in Excel &#8211; 3 Useful Formulas"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34037 size-large\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-1024x576.png\" alt=\"Workdays in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Excel<\/strong><\/a> is a powerful data analysis and management tool, that offers a versatile range of applications. It can be used to calculate workdays within a given month, making it an<strong> invaluable resource for keeping track of project deadlines, the duration of a task<\/strong>, <strong>calculating employee benefits<\/strong>, etc. This comprehensive <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-solver-functions\/\" target=\"_blank\" rel=\"noopener\"><strong>analysis<\/strong><\/a> enables <strong>better decision-making<\/strong> and <strong>strategic planning<\/strong>.<\/p>\n<p>In this article, we will explore the following functions to be able to calculate workdays in Excel &#8211;<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong>NETWORKDAYS<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>NETWORKDAYS + EOMONTH<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>NETWORKDAYS.INTL<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let us look at each of these methods in detail.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Calculate Workdays in Excel \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-a-Month-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Workdays-in-a-Month-in-Excel.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-workdays-in-excel\/#NETWORKDAYS\" title=\"NETWORKDAYS\">NETWORKDAYS<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-workdays-in-excel\/#NETWORKDAYS_EOMONTH\" title=\"NETWORKDAYS + EOMONTH\">NETWORKDAYS + EOMONTH<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-workdays-in-excel\/#NETWORKDAYSINTL\" title=\"NETWORKDAYS.INTL\">NETWORKDAYS.INTL<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-workdays-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"NETWORKDAYS\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">NETWORKDAYS<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Determining the count of working days manually can be quite challenging. It would be quite <strong>difficult and time-consuming to check your calendar<\/strong> and count weekdays week after week. Fortunately, Excel&#8217;s <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/networkdays-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>NETWORKDAYS<\/strong><\/a> Formula simplifies this task.<\/p>\n<p>The NETWORKDAYS function returns the number of whole working days between start_date and end_date. It excludes the weekends in the count, and you can also provide a list of holidays for it to exclude as well in the count.<\/p>\n<p>The syntax for this function is &#8211;<\/p>\n<p><strong>=NETWORKDAYS(<span style=\"color: #0000ff;\">start_date<\/span>, <span style=\"color: #ff6600;\">end_date<\/span>, <span style=\"color: #339966;\">[holidays]<\/span>)<\/strong><\/p>\n<p>where,<\/p>\n<ul>\n<li><strong><span style=\"color: #0000ff;\">start_date<\/span><\/strong> &#8211; A date that represents the start date. Required.<\/li>\n<li><strong><span style=\"color: #ff6600;\">ending date<\/span> <\/strong>&#8211; A date that represents the end date. Required.<\/li>\n<li><strong><span style=\"color: #339966;\">[holidays]<\/span><\/strong> &#8211; It contains a list of holidays that you need to exclude from your working calendar.<\/li>\n<\/ul>\n<p>In this example, we have the start date and end date mentioned in cells A2 and B2, and the holiday list is mentioned in the cell range F2:F12.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34015 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-1.png\" alt=\"Workdays in Excel\" width=\"713\" height=\"363\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-1.png 713w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-1-300x153.png 300w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/a><\/p>\n<p>Follow the steps below to calculate the workdays in Excel &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><\/strong>Enter the NETWORKDAYS formula.<\/p>\n<p><strong>=NETWORKDAYS<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34016 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-2.png\" alt=\"Workdays in Excel\" width=\"716\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-2.png 716w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-2-300x173.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Enter the first argument i.e. start_date. It is mentioned in cell A2.<\/p>\n<p><strong>=NETWORKDAYS(A2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34017 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-3.png\" alt=\"Workdays in Excel\" width=\"714\" height=\"402\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-3.png 714w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-3-300x169.png 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Enter the second argument i.e. end_date. It is mentioned in cell B2.<\/p>\n<p><strong>=NETWORKDAYS(A2,B2)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34018 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-4.png\" alt=\"Workdays in Excel\" width=\"717\" height=\"411\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-4.png 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-4-300x172.png 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/a><\/p>\n<p>There are <strong>66 working days<\/strong> between the dates of 1\/1\/2024 and 4\/1\/2024.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34019 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-5.png\" alt=\"Workdays in Excel\" width=\"716\" height=\"405\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-5.png 716w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-5-300x170.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/a><\/p>\n<p>Now, let us include the holiday list mentioned in cell range F2:F12 as the third argument.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>Enter the <strong>third argument &#8211; holidays<\/strong>. It is mentioned in cell range F2:F12.<\/p>\n<p><strong>=NETWORKDAYS(A2,B2,F2:F12)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34020 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-6.png\" alt=\"Workdays in Excel\" width=\"713\" height=\"406\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-6.png 713w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-6-300x171.png 300w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/a><\/p>\n<p>Since 3 holidays come in between the start date and end date (1\/1\/2024, 1\/15\/2024, and 2\/19\/2024), there are 63 working days only.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"NETWORKDAYS_EOMONTH\"><\/span><strong><span id=\"2\" style=\"color: #ff0000;\">NETWORKDAYS + EOMONTH<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You have the start dates mentioned in column A and you want to know the workdays in a month. For this, you can use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-endofmonth-function\/\" target=\"_blank\" rel=\"noopener\"><strong>EOMONTH<\/strong><\/a> function to get the last day of the month which is the indicated number of months before or after start_date.<\/p>\n<p>This <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/on-hold-how-to-calculate-average-formula-in-excel-10-useful-methods\/\" target=\"_blank\" rel=\"noopener\">formula is useful<\/a> when you want to know the number of working days in a month. Instead of typing the end date of each month individually, you can simply use the EOMONTH function to get the end <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/date-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\">date and then use NETWORKDAYS formula<\/a> to get the number of working days in that month.<\/p>\n<p>The syntax of EOMONTH is &#8211;<\/p>\n<p>=EOMONTH(<strong><span style=\"color: #0000ff;\">start_date<\/span>, <span style=\"color: #ff6600;\">months<\/span><\/strong>)<\/p>\n<p>where,<\/p>\n<ul>\n<li><strong><span style=\"color: #0000ff;\">start_date<\/span><\/strong> &#8211; A date that represents the start date. Required.<\/li>\n<li><strong><span style=\"color: #ff6600;\">months<\/span>\u00a0<\/strong>&#8211; The number of months before or after start_date. A positive value for months returns a future date; a negative value returns a past date.<\/li>\n<\/ul>\n<p>Follow the steps below to get the number of working days in a month &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Enter the NETWORKDAYS formula.<\/p>\n<p><strong>=NETWORKDAYS<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34021 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-7.png\" alt=\"Workdays in Excel\" width=\"586\" height=\"352\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-7.png 586w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-7-300x180.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Enter the first argument i.e. start_date. It is mentioned in cell A2.<\/p>\n<p><strong>=NETWORKDAYS(A2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34022 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-8.png\" alt=\"Workdays in Excel\" width=\"593\" height=\"384\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-8.png 593w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-8-300x194.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Enter the EOMONTH formula to get the end date.<\/p>\n<p><strong>=NETWORKDAYS(A2,EOMONTH<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34023 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-9.png\" alt=\"Workdays in Excel\" width=\"676\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-9.png 676w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-9-300x160.png 300w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Enter the first argument i.e. start_date. It is mentioned in cell A2.<\/p>\n<p><strong>=NETWORKDAYS(A2,EOMONTH(A2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34024 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-10.png\" alt=\"Workdays in Excel\" width=\"596\" height=\"358\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-10.png 596w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-10-300x180.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Enter the second argument i.e. months. It should be 0 as you want to know the days in that month itself.<\/p>\n<p><strong>=NETWORKDAYS(A2,EOMONTH(A2,0))<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34025 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-11.png\" alt=\"Workdays in Excel\" width=\"602\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-11.png 602w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-11-300x169.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span><\/strong> Press <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-dr-copy-downright\/\" target=\"_blank\" rel=\"noopener\">CTRL + D to copy<\/a> the formula down.<\/p>\n<p>This will give you the working days between the start date and the end of the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">month<\/a> date.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34026 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-12.png\" alt=\"Workdays in Excel\" width=\"592\" height=\"332\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-12.png 592w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-12-300x168.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"NETWORKDAYSINTL\"><\/span><strong><span id=\"3\" style=\"color: #ff0000;\">NETWORKDAYS.INTL<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The NETWORKDAYS.INLT is a <strong>flexible<\/strong> version of the NETWORKDAYS formula. It is used to calculate the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/workday-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>working days<\/strong><\/a> between the start and end date and additionally, it allows you to <strong>specify which days and how many of them should be considered non-working days.<\/strong> By <strong>default<\/strong>, it considers <strong>Saturday and Sunday<\/strong> as weekends.<\/p>\n<p>This is particularly useful for <strong>organizations with non-standard weekends <\/strong>like Sunday-Monday, Sunday-only, etc.<\/p>\n<p>The syntax of this formula is &#8211;<\/p>\n<p><strong>=NETWORKDAYS.INTL(<span style=\"color: #0000ff;\">start_date<\/span>, <span style=\"color: #ff6600;\">end_date<\/span>,<span style=\"color: #ffbf00;\">[weekend]<\/span>, <span style=\"color: #339966;\">[holidays]<\/span>)<\/strong><\/p>\n<ul>\n<li><strong><span style=\"color: #0000ff;\">start_date<\/span><\/strong> &#8211; A date that represents the start date. Required.<\/li>\n<li><strong><span style=\"color: #ff6600;\">ending date<\/span> <\/strong>&#8211; A date that represents the end date. Required.<\/li>\n<li><strong><span style=\"color: #ffbf00;\">[weekend] <\/span><\/strong>&#8211; It indicates the days of the week that are weekend days.<\/li>\n<li><strong><span style=\"color: #339966;\">[holidays]<\/span><\/strong> &#8211; It contains a list of holidays that you need to exclude from your working calendar.<\/li>\n<\/ul>\n<p>The following are the weekend number values that indicate the following weekend days &#8211;<\/p>\n<ul>\n<li>1 or omitted &#8211; Saturday, Sunday<\/li>\n<li>2 &#8211; Sunday, Monday<\/li>\n<li>3 &#8211; Monday, Tuesday<\/li>\n<li>4 &#8211; Tuesday, Wednesday<\/li>\n<li>5 &#8211; Wednesday, Thursday<\/li>\n<li>6 &#8211; Thursday, Friday<\/li>\n<li>7 &#8211; Friday, Saturday<\/li>\n<li>11 &#8211; Sunday only<\/li>\n<li>12 &#8211; Monday only<\/li>\n<li>13 &#8211; Tuesday only<\/li>\n<li>14 &#8211; Wednesday only<\/li>\n<li>15 &#8211; Thursday only<\/li>\n<li>16 &#8211; Friday only<\/li>\n<li>17 &#8211; Saturday only<\/li>\n<\/ul>\n<p>Follow the steps below to get the number of working days in a month considering only Sunday as non-working day &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Enter the<strong> NETWORKDAYS.INTL<\/strong> formula.<\/p>\n<p><strong>=NETWORKDAYS.INTL<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34027 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-13.png\" alt=\"Workdays in Excel\" width=\"710\" height=\"409\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-13.png 710w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-13-300x173.png 300w\" sizes=\"(max-width: 710px) 100vw, 710px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Enter the first argument i.e. <strong>start_date<\/strong>. It is mentioned in cell A2.<\/p>\n<p><strong>=NETWORKDAYS.INTL(A2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34028 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-14.png\" alt=\"Workdays in Excel\" width=\"717\" height=\"407\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-14.png 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-14-300x170.png 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Enter the second argument i.e. <strong>end_date<\/strong>. It is mentioned in cell B2.<\/p>\n<p><strong>=NETWORKDAYS.INTL(A2,B2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34029 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-15.png\" alt=\"Workdays in Excel\" width=\"714\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-15.png 714w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-15-300x168.png 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Enter the third argument i.e. <strong>weekend<\/strong>. It should be 11 as Sunday is considered a non-working day.<\/p>\n<p><strong>=NETWORKDAYS.INTL(A2,B2,11<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34030 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-16.png\" alt=\"Workdays in Excel\" width=\"727\" height=\"406\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-16.png 727w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-16-300x168.png 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span><\/strong> Enter the fourth argument i.e. <strong>holidays<\/strong>. It is mentioned in cell range F2:F12.<\/p>\n<p><strong>=NETWORKDAYS.INTL(A2,B2,11,F2:F12)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34031 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-17.png\" alt=\"Workdays in Excel\" width=\"715\" height=\"426\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-17.png 715w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-17-300x179.png 300w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p>This will provide you with the number of working days between the start and end date mentioned excluding Sundays.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34032 size-full\" title=\"Workdays in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-18.png\" alt=\"Workdays in Excel\" width=\"709\" height=\"409\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-18.png 709w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Workdays-in-Excel-18-300x173.png 300w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong><span style=\"color: #ff0000;\">Conclusion<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can harness the capabilities of <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Excel<\/strong><\/a> for workday calculations and bring efficiency and accuracy to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/project-management-with-microsoft-teams\/\" target=\"_blank\" rel=\"noopener\"><strong>project management<\/strong><\/a> and scheduling. Whether utilizing the basic <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/networkdays-function-48e717bf-a7a3-495f-969e-5005e3eb18e7\" target=\"_blank\" rel=\"nofollow noopener\"><strong>NETWORKDAYS<\/strong><\/a> function, incorporating EOMONTH for monthly analyses, or customizing workweek configurations with NETWORKDAYS.INTL, Excel has an in-built function for each purpose.<\/p>\n<p><span style=\"font-weight: 400;\">Download our <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\"><strong>141 Free Excel Templates and Spreadsheets<\/strong><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful data analysis and management tool, that offers a versatile range of applications. It can be used to calculate workdays within a given month, making it an invaluable resource for keeping track of project deadlines, the duration of a task, calculating employee benefits, etc. This comprehensive analysis enables better decision-making and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":34037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,528,358],"tags":[1544,1542,1545,1543],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34007"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=34007"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34007\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/34037"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=34007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=34007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=34007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}