Tools / Dates and deadlines
Business days between two dates
Both dates count if they are working days, the same way NETWORKDAYS works.
- Working days
- 19
- Calendar days
- 29
- Holidays on working days
- 2
Do it in a spreadsheet
A2from dateB2to dateHolidays!A2:A20holiday dates on their own tab
How it works
NETWORKDAYS.INTL counts both ends. The seven-digit code starts on Monday, and 1 means a day off, so "0000011" is a Saturday and Sunday weekend. Keep the holiday dates on their own tab and point the last argument at them.