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
- Pick a date for "Starting date".
- Enter the business days to add in days.
- Type the holidays to skip. This one is optional.
- 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:
- Business Day Calculator - Count the business days between two dates, skipping...
- Business Interruption Insurance Calculator - Estimate business interruption insurance needs based on...
- Business Loan Calculator - Calculate monthly payments, total interest, and...
- Business Mileage vs Actual Expense Calculator - Compare IRS standard mileage deduction vs actual vehicle...
- Business Valuation Calculator - Estimate business value using multiple valuation methods