Project Timeline · Free · No account
An event timeline, one column per day, with the big day marked.
The daily setup shows 60 days, one column each, with weekends shaded and today highlighted. Bookings, preparation, the day and the follow-up are phases in their own colours, and the event itself is a milestone.
- Excel 2016 and later
- Calculations checked in LibreOffice
- Choose the viewPick one column per day, week or month, how many to show, and which day your weeks start on.
- Name the phasesType the phases in order, one per line. Each gets its own bar colour. Switch on owners, % complete and milestones if you want them.
- Type the datesDownload the workbook and type each task with its start and finish dates. The bars appear on the Timeline sheet as you type.
Build your workbook
Preview: Event timeline by day. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
What is different in this setup
People planning a party, a wedding, a conference or a launch over a few weeks, who need to see what happens on which day.
- One column per day, 30, 60 or 90 days.
- Weekends shaded behind the bars, so the working days stand out.
- Owners for venue, caterer and photographer.
Sheets included (5)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- TasksOne row per task, with its start and finish dates. Start typing in row 6.
- TimelineEach of the first 200 tasks as a bar across 60 days, coloured by phase, with progress, milestones and today marked.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
- SettingsValues used by the workbook, such as reminder windows. Change them here.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
Can weeks start on Sunday?
Yes. Choose Sunday in the builder and the Timeline starts each week on a Sunday.
Can I show more than 90 days?
Not in the daily view. Use the weekly view for longer plans, or move the daily window on Settings to see a later period.
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the Project Timeline builder.