Loona Automation

Work Hours Between Two Dates Calculator

Planning a project, a leave balance or a contract? Count the actual workdays and work hours between any two dates — weekends and federal holidays handled.

In short: count calendar days, workdays under your chosen weekly pattern, and total scheduled work hours between two dates, with the 11 US federal holidays (OPM schedule) optionally excluded when they fall on a workday.
Time Card CalculatorHours CalculatorOvertime CalculatorCalifornia Overtime CalculatorTime and a Half CalculatorMinutes to Decimal Hours Converter

Work Hours Between Two Dates Calculator

How It Works — The Rule Behind This Calculator

The calculator walks the range day by day: a day counts when it matches your work pattern (Monday–Friday by default) and — if you choose — is not a US federal holiday. The holiday list is generated from the Office of Personnel Management (OPM) schedule: the 11 federal holidays, with the floating ones (MLK Day, Memorial Day, Thanksgiving and the rest) computed by their official weekday rules for whatever years your range covers, so ranges spanning several years stay correct.

Note that "federal holiday" and "day off" are not identical: private employers are not required to close on federal holidays, and observed-holiday shifting (when July 4 falls on a weekend) follows your employer's policy. Treat the exclusion list printed with your result as the assumption, and adjust the pattern if your workplace differs.

Related Hours Tools

Frequently Asked Questions

Which holidays are excluded?

The 11 US federal holidays from the OPM schedule: New Year's Day, MLK Day, Washington's Birthday, Memorial Day, Juneteenth, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving and Christmas. The ones inside your range are named in the result.

Does the end date count?

Yes — both the start and end dates are inclusive, which is how project and leave planning usually counts.

Can I count a non-standard work pattern?

Yes. Tick any combination of days — for example Tuesday–Saturday — and the count follows that pattern across the whole range.

My company gives the day after Thanksgiving. Is it excluded?

Not automatically: it is a common company holiday but not a federal one. Subtract it manually (one workday, or your hours-per-day figure) if your employer closes that day.

Disclaimer: Estimates only — not payroll or legal advice. Your employer's payroll rules and state law control your actual pay. Figures are rounded for display; your pay stub and payroll department are the official record.

How it works — the formula

Pick a start date and an end date — both days count. The calculator walks through every calendar day in the range one by one, keeps the days that match the weekly pattern you tick, optionally removes US federal holidays that land on those pattern days, and multiplies the workdays that remain by your hours per day.

The formula:
Workdays = days in the range (start and end included) that match your weekly pattern, minus federal holidays falling on those days if you chose to exclude them
Work hours = workdays × hours per day

Worked example

Take the range the page opens with: Monday 2 November to Friday 13 November 2026, a Monday-to-Friday pattern, 8 hours per day, federal holidays excluded. The range holds 12 calendar days, of which 10 are Monday-to-Friday days. Veterans Day falls on Wednesday 11 November, inside the range and on a workday, so it is excluded — leaving 9 workdays and 9 × 8 = 72.00 work hours, with the calculator listing Veterans Day by name as the one holiday excluded.

Frequently asked questions

What if I enter the end date before the start date?

The calculator simply swaps them and works on the range between the two dates. The totals are the same whichever way round you type them.

A federal holiday falls on a Saturday. Is the Friday or Monday taken off instead?

Not by this calculator. A holiday is excluded only when the holiday’s own date is one of your selected workdays; the page does not shift observance to a neighbouring weekday the way federal offices do. If your employer observes it on the Friday or Monday, untick that day in the pattern for that range.

Can I count a range that spans two different years?

Yes. The calculator builds the federal holiday list for every year the range touches, so a range running from December into January excludes the holidays at both ends correctly.

Can different days have different hours — say 8 hours on weekdays but 4 on Fridays?

No. One hours-per-day figure is applied to every workday in the range. For a mixed pattern, run the range twice — once for the full days and once for the short days — and add the two totals.

Does the total allow for lunch breaks?

No — your hours-per-day figure is taken exactly as entered. If you want breaks removed, enter your net working hours per day instead: 7.5 rather than 8, for example, for a day with a 30-minute unpaid lunch.

Embed this calculator on your website — free

Add this calculator to your own website or blog — it is completely free, needs no sign-up, and always shows the latest version. Copy the code below and paste it into your page where you want the calculator to appear. Keeping the small “Powered by Loona Automation” credit line under the embed helps keep this tool free — but you are free to style or remove it; the tool works either way.