Jira & Confluence 
Bitrix24 Gantt chart · Excel · automatic bars
Simple Gantt chart in Excel — type dates and see the plan
Short answer. Add tasks, owners, start dates, durations and percent complete. End date: start + duration − 1 (calendar days).
- Review progress and dependenciestype the date
Check your own case.
Use a recurring review cadence that fits the project.
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
Tasks · dates · weekly bars
Estimate the plan, then open the Gantt chart
Enter the number of tasks, completed tasks and average duration. The workbook adds owners, dependencies, start dates and a weekly timeline that redraws automatically.
- Give every task one accountable owner.
- Add dependencies, approvals and nonworking days before sharing dates.
- Update progress from completed work and record schedule decisions.
Planning aid only. Count-based progress and task-days do not predict or guarantee a delivery date; dependencies and parallel work matter.
Lida, Layers template assistant
Tell me task count, completed tasks and average duration: I will summarize the plan.
Open the complete Excel Gantt chart and Word review checklist below.
Deadlines
The rules, with the source
| What | Deadline | Source |
|---|---|---|
| End date | start + duration − 1 | calendar days |
| Weekly bar | week intersects the task start and end | conditional formatting |
| Progress | completed tasks ÷ task count | simple count, not forecast |
| Open task-days | remaining tasks × average duration | rough workload indicator |
Task counts and task-days do not model dependencies, parallel work, resources or uncertainty and do not guarantee a finish date.
Step by step
What to do, in order
1
List the work
Use concrete tasks with one accountable owner.
2
Connect the plan
Add dates, dependencies, approvals and nonworking days.
3
Review from evidence
Update completion and record decisions when the plan changes.
Questions
Is the Gantt template free?
Yes. Fill it in and download Excel without signing up.
Do the bars update automatically?
Yes. Change start date or duration and the weekly conditional-formatting bars redraw.
Can I add more than 20 tasks?
Yes. Insert rows and extend formulas and conditional formatting carefully.
Does percent complete predict the finish date?
No. It is a status input; dependencies, resources and risk still control the schedule.
Are dates calendar or business days?
This simple version uses calendar days. Adapt it if the project requires a workday calendar.
Other documents
Keep the papers in one place
Letters, receipts and notices in one folder you can share with family or a lawyer. The templates and the editor are free; Layers is free for up to 20 people.
Planning aid only. Validate owners, dependencies, calendars, resources and commitments with the project team.