Quick answer
Exclude bank holidays from working day calculations in Excel with a holiday list.
=NETWORKDAYS(A2,B2,$H$2:$H$20)
When to use this formula
Use it when you need a repeatable spreadsheet calculation for invoice due dates, project plans, payroll checks, support SLAs, or other weekday-based deadlines.
Common checks
- Make sure your date cells are real dates, not text.
- Keep public holidays in a separate list.
- Confirm whether the start date should count.
Need a quick answer without spreadsheet setup?
FAQs
How do I exclude bank holidays?
Create a list of holiday dates and pass that range into NETWORKDAYS or WORKDAY.
Do holiday names matter?
No. Excel needs the holiday dates; names are optional for your own reference.
Can I use this for UK bank holidays?
Yes, if your holiday list contains the relevant UK bank holiday dates.