Working Days Calculator
Enter a start date, an end date and the number of holidays to skip. From 1 January to 31 December 2026 there are 261 days Monday-to-Friday.
How the working days calculator works
A working day (or business day) is a day you work, usually Monday to Friday. This calculator counts every day from the start date to the end date, inclusive, removes weekend days and subtracts the holidays you list. It does not know your local holiday calendar, so enter the number of holidays that fall on workdays.
The formulas
Example: From 1 January to 31 December 2026 there are 365 calendar days and 104 days of weekends, leaving 261 days before holidays. That is about 52.2 weeks of work.
Notes and limits
- Both the start and end dates are counted.
- Holidays are entered as a count because holiday calendars differ by country, state and employer.
- For Excel use =NETWORKDAYS(start, end, holidays).
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Related: First day of month formula in Excel
Frequently asked questions
How do I count working days between two dates?
Count the days, remove weekends and subtract holidays. In Excel use NETWORKDAYS.
Are the start and end dates included?
Yes, both are counted.
How many working days are in 2026?
Without holidays there are 261 days Monday-to-Friday.
Can it handle a 6-day week?
Yes. Choose Monday to Saturday.
Need a custom calculator or spreadsheet built for your business?
Talk to usMore free tools: All free calculators · Time card calculator · Salary to hourly calculator · Timesheet template