StatGardenREF. DESK
Calculators/Date & time/Working days
Date & time

Working days calculator

Counts weekdays between two dates, less any holidays.

What this calculator does

Working days works out counts weekdays between two dates, less any holidays. Enter your own figures above and the answer updates as you type: nothing is fixed in the code, so the result reflects exactly the numbers you supply.

The formula this calculator evaluates is printed under the tool and explained below, so you can check the working by hand or reuse it in a spreadsheet.

The formula

FormulaBusiness days = total days − weekend days − holidays falling on a weekday

The inputs explained

FieldWhat to enter
Start dateA calendar date.
End dateA calendar date.
Public holidays in the periodA number. Starts at 0.

Worked examples

Every figure in the tables below is produced by this page’s own calculator at build time, so the numbers and the tool always agree. Select any row to load that scenario.

How the answer changes with public holidays in the period

Every other input is held at the calculator’s starting values while public holidays in the period varies. Select any row to load that scenario into the calculator.

How the answer changes with public holidays in the period
Public holidays in the periodWorking daysCalendar daysWeekend days
1639026
2629026
5599026
10549026
20449026
50149026