Working days calculator

Find out when a job that takes a number of working days will finish, skipping weekends, public holidays and your own closures. You can also count the working days between two dates. Handy for quotes, schedules and telling a client when to expect the work. Nothing you enter is sent anywhere.

Contract deadlines, weather delays and similar terms follow your agreement with the client. This tool only counts days, skipping the days off you choose. It does not know about weather, deliveries or inspections.

Dates and days What do you want to find?

Start date (day 1)

Working days

The start date counts as day 1. If the start date is a day off, the next working day is day 1.

Days off Weekend Holidays and closures

No holiday list is built in, because holidays differ by country and region. Paste your public holidays and company closures here, one date per line. A column copied from Excel works too.

Result

End date

—

A holiday that falls on a weekend day is counted once, as a weekend day.

Same calculation in Excel or Google Sheets

=WORKDAY.INTL(start-1, days, weekend, holidays)

holidays is the cell range with your holiday dates. More in Project end dates in Excel with WORKDAY.INTL.

Calendar

Grey days are days off. The small number under each date is the working day count (1, 2, 3...).

Example

A 3-day job starts on Friday, October 9, 2026. Weekends are Saturday and Sunday, and Monday, October 12 is a holiday. Friday the 9th is day 1. Saturday, Sunday and Monday are skipped, Tuesday the 13th is day 2, and Wednesday, October 14 is the end date. That is 6 calendar days.

For a job that runs over the year-end break, add the closure dates to "Holidays and closures" and they are skipped. You can do the same for a client's or supplier's days off.

Also free: Prorated rent calculator · Job profit calculator · 日本語版（工期・稼働日計算）

Built with the help of AI; the calculations are covered by tests.