Your Cart
Loading

Gantt Chart Planner: Excel & Google Sheets Template

On Sale
£1.49
£1.49
Added to cart

Gantt chart template for Excel and Google Sheets: add tasks, durations and predecessors and the timeline builds in working days, skipping UK bank holidays.


Launch price until 23-Jan-2027. The price goes up after that date.


Plan a project on one sheet: enter your tasks, durations and predecessors, and the Gantt chart builds itself in working days, skipping weekends and UK bank holidays.


WHAT YOU GET (instant download)

- Gantt_Chart_Planner_v1.2_BLANK.xlsx: blank planner, start here

- Gantt_Chart_Planner_v1.2.xlsx: filled example project

- Instructions.pdf: one page, with the Google Sheets copy link, the video link and support


Questions? Email info@opscendsolutions.com.

Digital downloads can't be returned, but if a file is faulty, email me and I'll sort it.


FEATURES

- Up to 100 tasks and a 30-week timeline; weeks start Monday or Sunday

- Durations in working days. Weekends and England & Wales bank holidays 2026–2029 (32 dates) are skipped, and you can add your own shutdown days.

- Finish-to-start dependencies (up to 3 predecessors per task) and an optional start-date override

- 6 colour-coded phases (rename them on the Phases sheet); done tasks turn green; 0-day milestones show as ◆

- 5 task statuses: Not started, Late start, In progress, Overdue, Done

- Summary panel: status counts, total tasks, % complete (duration-weighted), next milestone and its date

- A Check column that flags entry problems (e.g. phase not in list, % done not 0–100%, date not a date)

- No macros or add-ins


WORKS WITH

- Google Sheets (a copy link is in Instructions.pdf)

- Microsoft Excel: Tested in Google Sheets and Excel for the web


PLEASE NOTE

- Please note that Excel date formatting is region locked, which can invert months/days. To avoid any issue, type dates as 5-Oct-2026 format instead of XX/XX/YYYY so Excel and Sheets both read them correctly in any country/region

- This is a digital download, and nothing physical is shipped.

- Finish-to-start links only: no lags, float or critical path.

- Bank holiday dates: check gov.uk/bank-holidays before relying on them.

- Licence: personal or single-business use; do not resell or redistribute.


HOW THIS WAS MADE

Information Opscend Solutions designed this planner and decided what it does. Under our direction, we used AI tools to help build the spreadsheet formulas and layout, draft this description and run checks. The how-to steps in the file were written by us. The finished files were tested in Google Sheets and Excel for the web before listing. Images show the real example file.

You will get a ZIP (142KB) file