Working Days Calculator
Calculate business days between two dates, excluding weekends and holidays.
Advertisement
Related Calculators
Advertisement
Plan Your Projects with Precision
This calculator is an essential tool for project management, HR, and business planning. It determines the number of working days (Monday through Friday) between two dates. You can also input a list of public holidays to exclude them from the count for a more accurate result.
The Calculation Explained
The calculator iterates through each day from the start date to the end date. It checks the day of the week for each date and counts it only if it is not a Saturday or Sunday. If a list of holidays is provided, it also checks if the date matches any of the specified holidays before counting it.
How to Use the Calculator
- Start Date & End Date: Select the beginning and end of your date range.
- Add Holidays (Optional): In the text box, enter any holidays that fall within your date range, one per line, in YYYY-MM-DD format.
- Calculate: The tool will display the total number of working/business days.
Real-World Example
You need to find the number of working days in December 2024, excluding Christmas Day.
- Start Date: 2024-12-01
- End Date: 2024-12-31
- Holidays: 2024-12-25
- December 2024 has 31 total days. It has 9 weekend days (Saturdays and Sundays). Christmas (Dec 25th) falls on a Wednesday.
- Calculation:
31 (total days) - 9 (weekend days) - 1 (holiday) = 21working days. - The calculator will show a result of 21.
Frequently Asked Questions (FAQ)
- What if a holiday falls on a weekend? The calculator simply checks if a date is a weekend day OR a holiday. If a holiday like December 25th falls on a Saturday, it is already excluded as a weekend day, so it won't be double-counted or cause an error.
- How do I format the holidays?
Use the international standard format
YYYY-MM-DD, and place each holiday on a new line. - Does this calculator count the start date? Typically, these calculators are inclusive of the start date but exclusive of the end date, but it's always good to test with a small range (e.g., a Monday to a Wednesday) to confirm the behavior. In most business contexts, this provides the correct number of workdays within the period.