Free Working Days Calculator - Calculate Workdays
Calculate the total number of working days in a date range excluding weekends and holidays.
Formula & Methodology
The Working Days Calculator counts the total days in your date range, subtracts the weekend days (about two per week), and removes any holidays you specify. The result is the number of business days available, which is what project timelines and delivery estimates usually need.
- Working Days = Total Days − Weekend Days − Holidays
- Weekend Days = FLOOR(Total Days / 7) × 2 + remainder weekend days
Worked Example
Using the Working Days Calculator: apply the formula above to your input values. For instance, Working Days = Total Days − Weekend Days − Holidays, then Weekend Days = FLOOR(Total Days / 7) × 2 + remainder weekend days. The tool performs each step instantly and shows the result.
Frequently Asked Questions
How are working days counted?
It counts weekdays between two dates, excluding weekends and optionally public holidays you specify.
Does it exclude holidays?
Weekends are excluded automatically, and you can account for holidays to get an accurate business-day total.
Why calculate working days instead of calendar days?
Business deadlines, payroll and project timelines usually run on working days, so calendar days can overstate available time.