Summary
Count weekdays between two dates.
Calculation details
Public holidays are not included because holiday calendars differ by place and year.
Formula
Count Monday through Friday while skipping Saturday and Sunday.
Worked example
Worked example
Friday and Monday produce 2 business days.
How it works
Enter the date range and whether to include the end date. Only Monday–Friday count; add local holidays yourself.
Frequently asked questions
Which days count as business days?
Monday through Friday. Saturdays and Sundays are excluded. Regional public holidays are not auto-detected.
Does include end date change the count?
Yes. Enabling include end date counts the end date when it is a weekday; otherwise the end date is excluded.
Will this match my payroll calendar?
Only if your payroll also treats weekdays as working days and you add holidays manually when required.