About this tool
Count the working days (business days) between two dates, or find the date that is a number of working days away, for project plans, notice periods, delivery estimates, SLAs and payroll. Weekends and the holidays you list are skipped.
Weekends around the world
Saturday and Sunday are the default, but you can choose any non-working days: Friday and Saturday (Saudi Arabia, Israel, Egypt, among others), Sunday only (common in parts of India and for six-day weeks), or Friday only (Iran). Tick the days that are not worked.
Holidays
Public holidays differ by country, region and company, so add your own: one date per line in YYYY-MM-DD format, optionally followed by a name. Holidays that fall on a working day are subtracted and listed below the results; holidays on a weekend don’t count twice. Click Example holidays to see the format. Your holiday list stays in the box only; it isn’t stored or sent anywhere.
Counting rules
- By default both the start and end date count when they are working days: Monday to Friday of one week is 5 working days. Untick Include start date to count the days after the start, which is how many deadlines (“within 10 business days of receipt”) are measured.
- In Add working days mode, the count starts on the next day: 1 working day after Friday is Monday. Negative numbers count backwards.
- Working hours are working days × hours per day, a quick estimate for capacity planning.
In spreadsheets, the same calculations are NETWORKDAYS.INTL and WORKDAY.INTL in Excel and Google Sheets.
FAQ
How do I calculate working days between two dates?
Pick the start and end dates. Weekends are excluded automatically; add public holidays (one date per line) to exclude them too.
How do I add business days to a date?
Choose “Add working days to a date”, pick the start date and enter the number of working days. Weekends and listed holidays are skipped.
Can I use a Friday–Saturday weekend?
Yes. Tick the days that are not worked; any combination is supported.
Are public holidays included?
You add them yourself, because they vary by country and company. Paste dates in YYYY-MM-DD format, one per line, optionally with a name.
Does it count the start and end dates?
Both are counted by default when they are working days. Untick either option to exclude it.
What is the Excel formula for this?
NETWORKDAYS.INTL(start, end, weekend, holidays) counts working days, and WORKDAY.INTL(start, days, weekend, holidays) adds them.