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

=NETWORKDAYS.INTL(A2,B2,"0000011",Holidays!A2:A20)
  • A2 from date
  • B2 to date
  • Holidays!A2:A20 holiday 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.

More dates and deadlines tools

Esc