# Excel NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates. NETWORKDAYS.INTL excludes Saturday and Sunday by default, but provides a way to specify which days of the week are considered weekends. The function can optionally exclude a list of holidays supplied as dates.

**start_date**- The start date.**end_date**- The end date.**weekend**- [optional] Setting for which days of the week should be considered weekends.**holidays**- [optional] A reference to dates that should be considered non-work days.

NETWORKDAYS.INTL calculates work days between two dates. Work days exclude weekends (Saturday and Sunday by default) and can optionally exclude holidays. This function is more robust that the NETWORKDAYS function, because it allows you to control which days of the week are considered weekends. The **weekend** argument is set using the codes listed in the table below.

NETWORKDAYS.INTL can also optionally take into account holidays. For the **holidays** argument, supply a range that contains holiday dates. These are also treated as non-working days and will not be included in the result.

In the example shown, the following formulas are used:

D4=NETWORKDAYS.INTL(B4,C4) D5=NETWORKDAYS.INTL(B5,C5,17) D6=NETWORKDAYS.INTL(B6,C6,1,B9:B10)

Weekend number |
Weekend days |

1 (default) | Saturday, Sunday |

2 | Sunday, Monday |

3 | Monday, Tuesday |

4 | Tuesday, Wednesday |

5 | Wednesday, Thursday |

6 | Thursday, Friday |

7 | Friday, Saturday |

11 | Sunday only |

12 | Monday only |

13 | Tuesday only |

14 | Wednesday only |

15 | Thursday only |

16 | Friday only |

17 | Saturday only |

### Mask for workdays

The WORKDAY.INTL can also accept a "mask" to specify weekends for the weekend argument. The mask is provided as a string of 7 characters which must be either 1 or zero. In this scheme, the number 1 means weekend and the number zero means workday. The first digit represents Sunday. For example, to count workdays in a week where only Monday, Wednesday, and Friday are workdays, the first option below:

NETWORKDAYS.INTL(start,end,"1010101") // workdays = M,W,F NETWORKDAYS.INTL(start,end,"1101011") // workdays = Tue, Thu NETWORKDAYS.INTL(start,end,"1111100") // workdays = Fri,Sat

### Notes:

- If start_date is greater than end_date, the the function returns a negative value.
- If start_date or end_date are out of range, NETWORKDAYS.INTL returns the #NUM! error.
- If weekend is invalid, NETWORKDAYS.INTL returns the #VALUE! error.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.