Business Days Calculator

Every calendar day from the start to the end is visited once. A day is a working day unless it falls on one of the weekend days you selected or matches a date in your holiday list. The three totals — weekend days, holidays skipped and working days — add up to the calendar days, and the week-by-week table shows where each working day sits so the count can be checked against a wall calendar. A holiday that falls on a weekend is counted once, as a weekend day.

“Working days between 1 and 30 September” means 22 to a payroll clerk (both days worked) and 21 to someone counting the days until the 30th. The switch chooses: inclusive counts the end date if it is a working day; exclusive stops the day before. Spreadsheet NETWORKDAYS is inclusive of both ends, which is this page's default.

The start date is day zero. The calculator steps forward one calendar day at a time and counts only the working days until it has counted N; the day it lands on is the result. So “10 working days after Friday 18 September” is Friday 2 October, the same answer as spreadsheet WORKDAY. Negative N steps backwards. If the start itself is a weekend day or a holiday, counting simply begins at the next working day and a note says so — some contracts instead say the clock starts on the next working day as day zero, which would give one day later; read the contract.

No public-holiday calendar is built in. Holidays differ by country, by region, by year, by employer and by whether a weekend holiday is observed on the Monday; a default that is right for one reader is wrong for another and silently changes deadlines. Paste your own list as YYYY-MM-DD dates, one per line or separated by commas; anything that is not a valid date is reported, not dropped. The weekend defaults to Saturday and Sunday but can be Friday–Saturday, Sunday only, or none. Nothing leaves the browser; the same four anonymous usage counts as the rest of the site apply.