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

Free, from Producfy

Get the next guide before you need it

One email when a new guide or tool goes up: working formulas, queries and scripts for spreadsheets, SQL and the CRM and billing exports that end up in them. At most one a week.

Esc