Working Days Between Two Dates

The Formula

Working days are calculated by subtracting weekends (Saturday and Sunday) and optionally public holidays from the total calendar days between two dates. The calculation iterates through each day in the date range, counting weekdays and skipping weekends. When the holiday option is enabled, specific fixed-date US federal holidays are also excluded from the working day total. This gives you the net number of business-relevant days for planning or compliance purposes.

Variable Definitions

How to Use This Calculator

1. 1

   Enter a start date and end date in YYYY-MM-DD format using the date pickers.

2. 2

   Select whether to include or exclude the start and end dates themselves from the count.

3. 3

   Choose whether to exclude US federal public holidays from the working day total (these add to the weekend exclusions).

4. 4

   The result shows working days, calendar days, weekend days, and identified holidays in the date range.

5. 5

   Use this information for project planning, contract terms, leave calculations, or deadline estimation.

Common Applications

• Calculating the number of business days between two dates for project deadline estimation or SLA compliance
• Determining working days for contract terms, notice periods, rental agreements, or legal deadlines
• Planning leave or vacation around weekends and public holidays to maximize time off
• Estimating team capacity by counting the exact working days available in a sprint or project window

Working days calculation excludes weekends and public holidays

Understanding the Concept

Working day calculations are essential for project planning, deadline estimation, contract milestones, and payroll. This calculator counts Monday through Friday as working days and excludes Saturdays and Sundays. The holiday exclusion covers major fixed-date US federal holidays (New Year's Day, Independence Day, Veterans Day, Christmas). Floating holidays like Thanksgiving and Labor Day (which depend on the day of the week) are not included in this calculator. For business contexts, knowing the exact number of working days between two dates helps with setting realistic delivery dates, scheduling team capacity, and calculating service-level agreement compliance. For example, a standard 5-business-day turnaround means a project starting on Thursday would be due by Wednesday of the following week, assuming no holidays. In HR contexts, working day counts are used to calculate accrued paid time off, determine probation periods, and measure absenteeism. Many service contracts use "business days" rather than calendar days to exclude weekends from delivery timelines. Freelancers and consultants also use working day calculations to estimate project timelines and set client expectations about turnaround times. Knowing that there are typically 21-23 working days in a month helps with capacity planning and realistic scheduling across teams and departments.

Frequently Asked Questions

Sources & References