Workdays Calculator
Determine the exact number of working days between two dates. Customize your workweek by selecting which days to include, and specify any public holidays to exclude from the count. Ideal for project planning, deadline tracking, and HR calculations.
How to Use the Workdays Calculator
- Select Date Range: Choose a "Start Date" and an "End Date" for the period you want to analyze.
- Define Your Workweek: In the "Define Your Workweek" section, check the boxes for the days that are typically considered workdays for you (e.g., Monday through Friday).
- List Holidays (Optional): In the "Holidays" text area, enter any public holidays or specific non-working days that fall within your selected date range. Enter each holiday date in YYYY-MM-DD format. You can put each holiday on a new line or separate multiple dates on the same line with a comma.
- Choose Calculation Option: Decide if you want to "Include end date in calculation."
- If checked (default), the end date itself will be counted as a workday if it meets your workweek and holiday criteria.
- If unchecked, the calculation considers the period up to, but not including, the end date.
- Calculate: Click the "Calculate Workdays" button.
- Review Summary: The results will show:
- The selected Date Range.
- Total Calendar Days in that period.
- Number of Excluded Non-Workdays (your defined weekend days).
- Number of Excluded Holidays that fell on one of your defined workdays.
- The final Net Workdays.
Understanding Workday Calculations
This calculator determines the number of working days by taking the total number of calendar days in your selected period and then subtracting non-working days based on your inputs.
- Total Calendar Days: The raw number of days from the start date to the end date. If "Include end date" is checked, this count includes both.
- Non-Workdays (Weekends): Based on the days you *uncheck* in the "Define Your Workweek" section. For example, if you only check Monday to Friday, Saturdays and Sundays within the period will be counted as non-workdays.
- Holidays on Workdays: The tool checks each date in your specified holiday list. If a holiday falls on a day that you've defined as a workday (and is within your date range), it's counted here and subtracted from the potential workdays. Holidays falling on your defined non-workdays (e.g., a public holiday on a Saturday, if Saturday is not a workday for you) are not double-counted as an exclusion.
- Net Workdays: This is the final result: Total Calendar Days - Non-Workdays (Weekends) - Holidays that occur on Workdays. (Adjustments are made if "Include end date" is unchecked to reflect one less day in the total span being considered for workdays).
Frequently Asked Questions (FAQ)
How do I format the holiday dates?
Please enter each holiday date in the YYYY-MM-DD format (e.g., 2024-12-25 for December 25th, 2024). You can list multiple holidays by putting each on a new line or by separating them with commas (e.g., 2024-01-01, 2024-05-27).
What if a holiday falls on a weekend that I've already excluded?
The calculator is designed to avoid double-counting exclusions. If a date is already marked as a non-workday (e.g., a Saturday you've unchecked) and it's also in your holiday list, it will be counted as a non-workday (weekend). The "Holidays on Workdays" count only includes holidays that specifically fall on a day you've defined as part of your workweek.
Can I calculate workdays for a period spanning multiple years?
Yes, you can select start and end dates that span across multiple years. The calculator will correctly account for leap years and the day of the week for all dates within the range.
Is there a limit to the number of holidays I can enter?
While there isn't a strict technical limit, entering an extremely long list of holidays might affect browser performance slightly. For typical use (e.g., national holidays for a year or two), it should work efficiently.