Free tool

Project Timeline & Working Days Calculator

Enter a start date and how many working days each task takes. Weekends and the holidays you list are skipped, and each task starts on the next working day after the one before. You get a start and end date for every task, the project end date and the total working days.

Updated 2026-11-14. Runs in your browser: what you type is not sent anywhere or saved, and is gone when you close the page.

No public holidays are built in. List the ones that apply to you.

US federal holidays 2027 (copy and paste)
2027-01-01
2027-01-18
2027-02-15
2027-05-31
2027-06-18
2027-07-05
2027-09-06
2027-10-11
2027-11-11
2027-11-25
2027-12-24
2027-12-31
Observed dates for federal employees, per OPM. Private employers and banks may differ.

Tasks, in order

Schedule

TaskStartEndDays
Project--0

Project end date

-

Working days 0 · Calendar days 0

Want these dates as a Gantt chart in Excel? See our Excel Gantt schedule template (USD 7) or open it on Gumroad (USD 7).

What is a working day?

A working day is a day the work actually happens. If a task takes 5 working days and you start on a Thursday, it does not end the following Monday: Saturday and Sunday do not count, and neither does a holiday or a day the team is off. Counting this by hand on a calendar is slow and easy to get wrong, especially across the end of the year. This calculator counts the days for you and lays the tasks out one after another, so you can see when each one starts and ends and when the whole project is done.

How the calculator works

It uses exactly these rules:

Working day = not Sat/Sun (if Skip weekends is on) and not in your holiday list
Task start  = the first working day on or after the day it can begin
Task end    = the Nth working day counting the start day as day 1 (N = working days)
Next task   = can begin the day after the previous task ends
Calendar days = Project end - Project start + 1

Worked example

Say the project starts on Monday 2026-12-21, weekends are skipped, and 2026-12-25 and 2027-01-01 are holidays. There are three tasks: Plan (3 working days), Build (5) and Review (2).

  1. Plan: 2026-12-21 to 2026-12-23 (Monday to Wednesday).
  2. Build: starts Thursday 2026-12-24 (day 1). The 25th is a holiday and the 26th and 27th are a weekend, so days 2 to 5 are the 28th to the 31st. It ends 2026-12-31.
  3. Review: 2027-01-01 is a holiday and the 2nd and 3rd are a weekend, so it runs 2027-01-04 to 2027-01-05.
  4. The project ends Tuesday 2027-01-05: 10 working days, 16 calendar days.

Common questions

How do I add N business days to a date, skipping weekends and holidays?

Add one task with N working days and list your holidays. The calculator counts the start date as day 1. To get the date N working days after a date (the way Excel's WORKDAY function counts), set the start date to the day after it. Example: 7 business days after Friday 2026-12-18, with 2026-12-25 as a holiday, is Wednesday 2026-12-30.

Can it find a due date that excludes US or UK holidays?

Yes, if you type those holidays into the list. No country's holidays are built in, so the result is only as complete as the dates you enter. For US federal holidays in 2027, copy the list under the holidays box (source: OPM).

What it does not do

Draw the schedule as a Gantt chart in Excel

The Gantt Chart Project Schedule is a paid Excel template from us: enter a task, start date and duration; end dates, status and Gantt bars are calculated, with progress shading and late tasks highlighted. Day or week view, up to 200 tasks, optional skip weekends (Sat/Sun only). In the template each task has its own start date (no dependencies) and public holidays are not handled. No macros.

Gantt Chart Project Schedule on Gumroad · USD 7

Opens the Gumroad product page. The price shown there is the one that applies.

Screenshots and details of the Gantt Chart Project Schedule template

How to make a Gantt chart in Excel (free step-by-step guide)

How to make a weekly Gantt chart in Excel (free step-by-step guide)

All English templates, including free lite editions

About this tool