NETWORKDAYS convention

Working Days Calculator

Count business days between dates, or add and subtract working days.

In short

Working days between two dates are the business days left after excluding weekends and any public holidays. Enter a start and end date (or add a number of working days), choose your weekend rule and holiday list, and this calculator returns the exact business-day count or resulting date.

Working Days

Business days, your way

Count working days, not just calendar days

The working days calculator does two jobs. It counts the number of business days between two dates — skipping weekends and any public holidays you list — and it can add or subtract a number of working days from a date to find a business deadline. It’s the tool for anything measured in working days rather than calendar days: SLAs, delivery windows, notice periods, visa and passport processing, court and tax deadlines, and payroll cut-offs.

By default a weekend is Saturday and Sunday, but you can switch to a Friday–Saturday weekend (common in parts of the Middle East), a Sunday-only weekend, or turn weekend skipping off entirely. Tick exclude public holidays and paste the dates that apply to your country or company, and they’ll be removed from the count too.

Tip: Holidays are entered as YYYY-MM-DD and separated by commas, so you can match your own national or company calendar exactly.

How business days are counted

Between two dates, the calculator walks the calendar one day at a time from the day after the start date up to and including the end date, counting only the days that aren’t a weekend or a listed holiday. When adding working days, it steps forward (or back) skipping non-working days until it has moved the number you asked for, and returns the resulting date and its weekday.

Related tools

If you just need the plain number of calendar days between two dates, use the date difference calculator (which also has a quick weekends-excluded toggle). To move a fixed number of calendar days, use the date ± days calculator, and to find which weekday a date falls on, try the day of the week calculator.

FAQ

Common questions

How do I count working days between two dates?
Choose “working days between two dates”, enter the start and end dates, pick your weekend rule and optionally add public holidays. The calculator returns the number of business days, excluding weekends and any holidays you list. For plain calendar days, use the date difference calculator.
Can it add or subtract working days from a date?
Yes. Switch to “add / subtract working days”, enter a start date and a number of working days, and it returns the resulting business date and its weekday, skipping weekends and holidays.
Which days count as the weekend?
Saturday and Sunday by default. You can switch to a Friday–Saturday weekend, a Sunday-only weekend, or turn weekend skipping off to count every day.
Does it include public holidays?
Only if you add them. Tick “exclude public holidays” and paste the dates (YYYY-MM-DD) for your country or company, and they’ll be removed from the count.
Sources & standards
  • Method: business days counted excluding Saturdays and Sundays (weekend rule configurable) and any public holidays you provide — the same convention as spreadsheet NETWORKDAYS.
  • Note: holiday lists vary by country and employer, so enter your own dates.