Excluding Holidays
Key points
- Enter the holiday range
- See the formula
- Copy it
In NETWORKDAYS Builder, entering a holiday range also excludes holidays.
Steps
- Enter the holiday range
- See the formula
- Copy it
Keep a list of holidays in some cells.
Use "Build a NETWORKDAYS Formula" (free)
Tools that go well with this
- Build a Date Offset Formula: Build date offset formulas.
- Build a DATEDIF Formula: Build a DATEDIF formula.
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.