How to use this calculator
- Enter or choose start date.
- Enter or choose direction.
- Enter or choose business days.
- Enter or choose weekly days off.
- Enter or choose public holidays (one per line).
- The resulting date updates as you type. Use Copy result or Share to keep it.
Method
Result = the date reached after counting N working days from the start date (the start date itself is not counted)
- N
- the number of business days to add or subtract
- Working day
- a day that is neither a weekly day off nor a listed holiday
Worked example
- Start on Tuesday 22 December. Counting: 23rd (1), 24th (2).
- Skip Friday 25th (holiday), the weekend of 26–27, and Monday 28th (holiday).
- Continue: 29th (3), 30th (4), 31st (5).
Five business days after 22 December 2026, skipping 25 and 28 December, is Thursday 31 December 2026.
What the result means
Contracts and service levels often state deadlines in business days. Check whether yours counts the start day; this calculator follows the spreadsheet convention of starting with the next working day.
Assumptions and limits
- The start date is day 0 and is not counted.
- Only the holidays you enter are skipped.
- Cut-off times (for example, requests received after 5 pm count from the next day) are not applied.
Questions
Does the start day count?
No. As with spreadsheet WORKDAY functions, adding 1 business day to a Monday gives Tuesday. If your rule counts the start day, subtract one from the number you enter.
What if the start date is a holiday?
Counting still starts from the next working day, so the result is the same as starting on the last working day before it.