Tools / Dates and deadlines

Add business days to a date

The start date itself never counts, so 1 working day after a Friday is Monday.

Due date
Tue 2026-12-01
Start plus calendar days
Wed 2026-11-25

Do it in a spreadsheet

=WORKDAY.INTL(A2,B2,"0000011",Holidays!A2:A20)
  • A2 start date
  • B2 working days
  • Holidays!A2:A20 holiday dates on their own tab

How it works

WORKDAY.INTL steps forward one day at a time and only counts days that are not weekend days or holidays. Format the result cell as a date, or it shows a serial number.

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