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.
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-31Observed dates for federal employees, per OPM. Private employers and banks may differ.
Tasks, in order
Schedule
| Task | Start | End | Days |
|---|---|---|---|
| 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
- If the start date is a weekend or a holiday, the first task begins on the next working day.
- Working days must be a whole number from 1 to 9999. Rows with a blank number are skipped. Rows with 0, a fraction, a negative number or text are marked in red and left out.
- Holidays are dates in YYYY-MM-DD form, one per line (commas also work). Lines that are not a real date are counted and ignored.
- Tasks run one after another, never at the same time. Dates are calendar dates with no time zone or hours.
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).
- Plan: 2026-12-21 to 2026-12-23 (Monday to Wednesday).
- 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.
- 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.
- 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
- It does not know any country's public holidays. Only the dates you type are skipped.
- It does not run tasks in parallel, track progress, draw a Gantt chart or handle hours and part days.
- It does not remember your plan. Nothing is stored, so copy the dates out if you want to keep them.
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 7Opens 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 editionsAbout this tool
- Made with AI (Claude). The calculation is checked by automated tests, including the worked example above.
- A planning aid with simple date counting. Check deadlines that matter, such as contract dates, yourself.
- This page collects no personal data. No ads, no cookies and no browser storage; your inputs never leave your browser. Cloudflare Web Analytics (cookieless) counts page loads. The server only counts daily page views and buy-button clicks per page and referring site (no IP address, no user agent).