complete.tools

Business Days Calculator

Find the date a number of business days after or before any date, skipping weekends and any holidays you list.

What this tool does

Find the date a number of business days after or before any date, skipping weekends and any holidays you list. You fill in these fields: Starting date, Business days to add, and Holidays to skip. Some fields are optional. It shows target date, calendar days moved, and holidays skipped.

Inputs

  • Starting date: A date. Starts as today's date. The starting day itself is never counted.
  • Business days to add (days): A whole number. Accepts -100,000 to 100,000. Starts at 10 days. Use a negative number to count back.
  • Holidays to skip: Longer text, up to 5000 characters. Optional. Dates as YYYY-MM-DD, separated by commas, spaces or new lines.

How to use

  1. Pick a date for "Starting date".
  2. Enter the business days to add in days.
  3. Type the holidays to skip. This one is optional.
  4. Read the result: target date, calendar days moved, and holidays skipped. It appears once every required field has a valid value.

Worked examples

Example 1. Inputs:

  • Starting date: February 1, 2023
  • Business days to add: 10 days

Results:

  • Target date: February 15, 2023 (Wednesday)
  • Calendar days moved: 14
  • Holidays skipped: 0

How this is worked out: Feb 1 2023 is a Wednesday. Ten business days is exactly two work weeks, so the result is Wednesday Feb 15, 14 calendar days later.

Example 2. Inputs:

  • Starting date: December 24, 2024
  • Business days to add: 2 days
  • Holidays to skip: "2024-12-25"

Results:

  • Target date: December 27, 2024 (Friday)
  • Calendar days moved: 3
  • Holidays skipped: 1

How this is worked out: Dec 24 2024 is a Tuesday. Wed Dec 25 is a holiday and is skipped, Thu 26 is business day 1, Fri 27 is business day 2.

Example 3. Inputs:

  • Starting date: January 5, 2024
  • Business days to add: 1 day
  • Holidays to skip: "2024-01-06"

Results:

  • Target date: January 8, 2024 (Monday)
  • Calendar days moved: 3
  • Holidays skipped: 0

How this is worked out: Jan 5 2024 is a Friday. The listed holiday Sat Jan 6 is already a weekend day, so it changes nothing: the next business day is Monday Jan 8 and no holiday is counted as skipped.

Example 4. Inputs:

  • Starting date: January 6, 2024
  • Business days to add: 0 days

Results:

  • Target date: January 6, 2024 (Saturday)
  • Calendar days moved: 0
  • Holidays skipped: 0

How this is worked out: Adding 0 business days moves nothing, so the starting date is returned unchanged even though Jan 6 2024 is a Saturday.

Limitations

  • The weekend is always Saturday and Sunday.
  • Holidays come only from the dates you type in.
  • Counts whole calendar days and ignores time zones and the time of day.

FAQs

Q: Is the starting day counted?
A: No. Adding 1 business day to a Friday gives the following Monday.
Q: What if the starting date is a weekend day?
A: Counting begins with the next business day, so a Saturday plus 1 business day is the following Monday. Adding 0 returns the starting date unchanged, even when it is a weekend day.
Q: Can I count backwards?
A: Yes. Enter a negative number of days.
Q: How do I skip public holidays?
A: Type them into the holidays box as YYYY-MM-DD dates. The tool has no built-in holiday calendar.

Explore Similar Tools

Explore more tools like this one: