The NETWORKDAYS.INTL function in Excel is a useful tool for calculating the number of working days between two dates, taking into account customizable weekend days and holidays. It is particularly handy for scheduling tasks, project management, and time-sensitive calculations.
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments
| start_date | The initial date from which you want to start counting working days. |
| end_date | The final date up to which you want to count working days. |
| [weekend] | (Optional) A code or string that specifies which days of the week are considered weekends. You can use a number code or a custom string like “0001100” where 0 represents a workday and 1 represents a weekend day. The default is “0000000” (Saturday and Sunday as weekends). |
| [holidays] | (Optional) An optional list of dates representing holidays that should be excluded from the calculation. |
How to use
The NETWORKDAYS.INTL function is relatively straightforward to use. Here’s how you can use it with some examples:
Example 1: Calculating working days between two dates with default weekend settings (Saturday and Sunday).
|
1 |
=NETWORKDAYS.INTL(A2, B2) |
In this formula, A2 represents the start date, and B2 represents the end date. Excel will calculate the working days between these two dates, excluding weekends.
Example 2: Customizing weekend days.
|
1 |
=NETWORKDAYS.INTL(A2, B2, "0000011") |
Here, we’ve specified that only Friday and Saturday should be considered weekends. The formula will now exclude those days from the working day count.
Example 3: Including holidays.
|
1 |
=NETWORKDAYS.INTL(A2, B2, "0000000", C2:C4) |
In this case, we’re using a range C2:C4 to specify holidays. These dates will be excluded from the working day count.
Example 4: Using a custom weekend string.
|
1 |
=NETWORKDAYS.INTL(A2, B2, "1010101", C2:C4) |
Here, we’ve set a custom weekend pattern where Tuesday and Thursday are considered weekends. The formula takes this into account when calculating working days.
Example 5: Calculate working days between today and a future date.
|
1 |
=NETWORKDAYS.INTL(TODAY(), A2) |
This formula calculates the working days between the current date and the date specified in cell A2.
Additional Information
The NETWORKDAYS.INTL function is a versatile tool for managing working day calculations. Remember that the optional arguments, like customizing weekend days and specifying holidays, allow you to tailor the function to your specific needs. This can be especially valuable in various business and project management scenarios where different working day conventions apply.