日付・時間・暦項目 № 04.02

営業日・稼働日数計算機(平日カウント) - 無料オンライン計算ツール

土日や週末を除外した正味の営業日数・稼働日数を計算。納期管理や業務計画の立案に便利。

よく検索されるキーワード:how to calculate working days between two datesbusiness days calculator excluding holidaysproject deadline working days calculatorbillable hours calculator by working daysnet working days for payroll calculation

What is a business day, and why does it matter? A business day is a day on which normal commercial activity takes place - in most countries this means Monday through Friday, excluding weekends and public holidays. This calculation matters for project planning, payroll processing, legal deadlines (such as a contract notice period or a government application due date), and freelance billing, because counting plain calendar days produces inaccurate estimates - a 30-day project window often contains only 20–22 actual working days.

What is a business day, and why does it matter?

A business day is a day on which normal commercial activity takes place - in most countries this means Monday through Friday, excluding weekends and public holidays. This calculation matters for project planning, payroll processing, legal deadlines (such as a contract notice period or a government application due date), and freelance billing, because counting plain calendar days produces inaccurate estimates - a 30-day project window often contains only 20–22 actual working days.

Note: the definition of a "weekend" is not universal. India, the US, and most of Europe treat Saturday–Sunday as non-working. Gulf countries (UAE, Saudi Arabia) and Israel treat Friday–Saturday as the weekend instead. This calculator currently offers two options - "Sat & Sun Off" and "Sunday Only" - if your business operates in a Friday–Saturday-weekend region, please adjust results manually.

Formula and Methodology (NETWORKDAYS Standard)

This calculator uses a standard calendar-based method - the same logic used in most payroll and project-management software, such as Microsoft Excel's NETWORKDAYS function.

Total Calendar Days
End Date − Start Date + 1
Gross Business Days
Total Calendar Days − Weekend Days
Net Business Days
Gross Business Days − Public Holidays (falling on weekdays)
Billable Hours
Net Business Days × Hours per Day

Reference: Microsoft Excel NETWORKDAYS/NETWORKDAYS.INTL function documentation; ISO 8601 weekday numbering standard (Monday = day 1).

Step-by-Step Calculation Example

ステップごとの計算例

Example: Feb 13, 2026 to Mar 13, 2026, "Sat & Sun Off" selected, 1 public holiday, 8 hours/day

1
Total calendar days29 days
2
Subtract 8 weekend daysgross business days = 21
3
Subtract 1 public holidaynet business days = 20
4
Billable hours20 × 8 = 160 hours
Conclusion:Out of 29 calendar days, only 20 are actually working days - this gap is the most common source of unrealistic project timelines.
詳しい解説

Where do most business-day calculation errors actually come from?

The most common mistake is subtracting only weekends and forgetting holidays - which makes deadlines look more optimistic than they really are. A second common error is ignoring "half-day" holidays (such as a half-working day on a festival eve) - most simple calculators, including this one, don't handle that nuance. A third, more expensive mistake happens on international teams: India's public holiday calendar is completely different from Germany's or France's, so assuming "one calculator, one country setting" for a multi-country project is risky - each team member's local calendar needs its own calculation. France adds an extra layer entirely: the distinction between "jours ouvrés" (actually-working days) and "jours ouvrables" (legally workable days) is itself defined in the French Labour Code, and picking the wrong one skews leave and deadline counts.

Weekend Conventions by Region

India, US, Germany
Weekend DaysSaturday–Sunday
Option in CalculatorSelect "Sat & Sun Off"
France (jours ouvrés)
Weekend DaysSaturday–Sunday
Option in CalculatorSelect "Sat & Sun Off"
France (jours ouvrables)
Weekend DaysSunday only
Option in CalculatorSelect "Sunday Only"
UAE, Saudi Arabia
Weekend DaysFriday–Saturday
Option in Calculator⚠️ Not currently supported - adjust manually
Israel
Weekend DaysFriday–Saturday
Option in Calculator⚠️ Not currently supported - adjust manually
Related Planning Tools

Explore Connected Chronology & Work Schedule Tools

Planning project deadlines and workforce capacity often requires coordinating multiple time models. If you need to measure the total calendar span between two arbitrary dates (including weekends and leap days), use our Date Difference Calculator to isolate gross calendar intervals. To monitor real-time remaining days, hours, and minutes until a contractual milestone or product launch, check our Countdown to Date Calculator. For calculating daily shift clock-in times, unpaid break deductions, and billable timesheet totals, use our Time Duration Calculator.

よくある質問(FAQ)

Frequently Asked Questions

Are the start and end dates both counted?

Yes, this calculator treats both dates as inclusive - the same convention Excel's NETWORKDAYS function uses.

What if a holiday falls on a weekend?

It isn't subtracted separately, since that day is already counted as a weekend day.

Which option should I choose - "Sat & Sun Off" or "Sunday Only"?

If your office runs Monday to Friday, choose "Sat & Sun Off". If Saturday is also partly a working day (as in some Indian institutions, or France's "jours ouvrables" reckoning), choose "Sunday Only".

Can this handle half-day holidays?

No, it currently only supports full-day holidays.

Sources & References

関連する計算機

「営業日計算」とあわせてよく使われている計算ツール

全て見る 日付・時間・暦 →
期間算出№ 04.01

日付間隔・日数差計算機

開始日と終了日からその間の総日数、週数、月数、実日数を正確にカウント。スケジュール管理に最適。

Δt = Date₂ − Date₁ (days, weeks, months)計算機を開く
日付シフト№ 04.05

日付加減算・○日後○日前計算機

基準日から「○日後」「○週間後」「○日前」などの正確な該当日を計算。記念日や締切の確認に。

Target Date = Start Date ± (Y, M, W, D)計算機を開く
曜日判定№ 04.03

曜日計算機(指定日の曜日特定)

過去や未来の任意の日付が何曜日だったか・何曜日になるかを瞬時に判定。うるう年にも完全対応。

h = (q + ⌊13(m+1)/5⌋ + K + ⌊K/4⌋ + ⌊J/4⌋ − 2J) mod 7計算機を開く

高精度計算・プライバシー100%保護

全ての計算はお使いのブラウザ上でIEEE 754倍精度演算により実行されます。入力したデータは外部サーバーに送信・保存されることは一切ありません。