WHAT IS NETWORKDAYS.INTL FUNCTION IN MICROSOFT EXCEL?
NETWORKDAYS.INTL function released in Microsoft Excel 2010.
Have you got a query why Microsoft released new function similar to neworkdays?
In NETWORKDAYS function by default it treats Saturday and Sunday as weekends, and we can’t change. But, what if some processes or ogranizations weekends will be different. For example, XYZ company works on Saturday and Sunday, week offs are Monday, Tuesday. In this case NETWORKDAYS function will not be helpful. That is the reason Microsoft release NETWORKDAYS.INTL (international) function in Excel 2010.
SYNTAX OF NETWORKDAYS.INTL FUNCTION
NETWORKDAYS.INTL function has 4 functional arguments
— start_date and end_date are two required valid date values
— Weekend is optional argument and prepopulated built-in lists
— Holidays is optional argument, we can select range of cells or names (if defined).
(Check the below video to understand about how to work with NETWORKDAYS.INTL function in Microsoft Excel in details.)
EXAMPLES OF NETWORKDAYS.INTL FUNCTION
|1||In cell B2 enter 03/01/2020 and cell B4 enter 03/31/2020 and write formula||=NETWORKDAYS.INTL(B2,B4)||22|
|2||In cell B2 enter 03/01/2020 and cell B4 enter 03/31/2020 and write formula [note: enter holidays in G2 to G11 cells]||=NETWORKDAYS.INTL(B2,B4,11,G2:G11)||25|
|3||In cell B2 enter 03/01/2020 and cell B4 enter 03/31/2020 and write formula [note: enter holidays in G2 to G11 cells, define a name as Holidays]||=NETWORKDAYS.INTL(B2,B4,11,Holidays)||25|
|4||In cell B2 enter 03/01/2020 and cell B4 enter 03/31/2020 and write formula [note: enter holidays in G2 to G11 cells, define a name as Holidays]||=NETWORKDAYS.INTL(B2,B4,2,Holidays)||20|
If you see in example 3, we selected 11 in third (weekend) argument, here 11 represents Only Sunday is my week off. So the function exclude Sunday’s and return whole working days between the dates.
In example 4th, we selected, we selected 2 in third argument, here 2 represents Sunday, and Monday are week off’s. So the function exclude Sunday, and Monday’s and returns whole working days between the dates.
TIPS & TRICKS
- Networkdays.intl function is alternative to networkdays function and provides weekend option to select depends on our requirement
- We can use this function for resource planning, project planning etc.
- Click here to get the practice file used in the above video : https://app.box.com/s/6ndkc5y2qxo0in9cbydq7qf7gqij6ivf
- Refer how to use NETWORKDAYS function : http://msofficeguru.in/microsoft-excel/date-time-functions/excel-networkdays-function/