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

Esc