The `NETWORKDAYS.INTL` function in Excel is a useful tool for calculating the number of working days between two dates, with the flexibility to define custom weekend days. This can be particularly helpful for businesses and projects that do not adhere to the traditional Saturday-Sunday weekend model.
Here’s how to use the `NETWORKDAYS.INTL` function:
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Parameters
- `start_date`: This is the start date of the period you want to calculate the working days for. It must be a valid Excel date.
- `end_date`: This is the end date of the period. Like the start date, it should also be a valid Excel date.
- `[weekend]` (optional): This parameter determines which days are considered weekends. You can specify this using either:
- A number: Predefined values from 1 to 17 that denote different weekend combinations. For example, `1` denotes Saturday-Sunday and `2` denotes Sunday-Monday.
- A string: A 7-character string where each character represents a day of the week, starting from Monday. A “0” means it’s a working day, and a “1” means it’s a weekend. For example, `”0000011″` represents a weekend of Saturday-Sunday.
- `[holidays]` (optional): This is a range or array of dates to exclude from the working day count. These dates are treated as non-working days in addition to the weekends.
Example Usage
=NETWORKDAYS.INTL(A1, B1, 1, C1:C10)
- A1: Start date cell reference.
- B1: End date cell reference.
- 1: Indicates that the weekend days are Saturday and Sunday.
- C1:C10: A range that contains the holiday dates.
Example with Custom Weekend
=NETWORKDAYS.INTL(A1, B1, "0000110", C1:C10)
This uses `”0000110″` to define Friday and Saturday as weekends.
Notes
- If you omit the `[weekend]`, Excel assumes a standard Saturday-Sunday weekend by default.
- The `holidays` parameter is useful for excluding additional non-working days such as company-specific holidays or public holidays.
- Make sure your dates are in Excel date format for the function to operate correctly.
Utilizing the `NETWORKDAYS.INTL` function can greatly enhance your date calculations by offering flexibility in defining what days constitute your workweek.
Unlock Your Potential
Excel
Access
Power BI
