Others

How to Display Predecessor Dates and Duration in MS Project Milestones

Phi Hung Vo Oct 9, 2026 869 views

Question details

The user needs to display the duration, start date, and finish date of predecessor tasks within a milestone reporting section in Microsoft Project.

How to Display Predecessor Dates and Duration in Microsoft Project Milestones

Product: Microsoft Project
Device & OS: not provided
Scenario: Creating milestone reports and needing to show details of the tasks leading up to those milestones.
Observed behavior: Microsoft Project milestones have zero duration by definition and do not automatically mirror or duplicate predecessor task details in the milestone rows.

Before you start

Ensure you have your project schedule fully outlined with accurate task dependencies, and familiarized yourself with inserting and customizing columns in Microsoft Project.

Solution 1Recommended

Use Custom Flag Fields and Apply Filters

Since milestones have zero duration, use a custom Flag field to tag the specific tasks you need for your report, then filter the view to display only those tasks.

Microsoft Project does not support mirroring predecessor task details directly into milestone rows because milestones are designed to represent points in time rather than work phases. Duplicating task information can lead to WBS errors and tedious report maintenance.

Insert a Custom Column

Right-click any column header in your Gantt Chart view, select 'Insert Column', and choose a 'Flag' field (such as Flag1) from the dropdown list.

Rename the Flag Field

Right-click the newly inserted Flag column, select 'Custom Fields', and rename it to a descriptive title like 'Milestone Report'.

Tag Tasks for Reporting

Go through your task list and for every predecessor task or milestone you want to display in your report, change the Flag value to 'Yes'.

Apply a Filter

Navigate to the 'View' tab on the ribbon, click the 'Filter' dropdown in the Data group, choose 'New Filter', and set the criteria to only show tasks where your Custom Flag equals 'Yes'.

Use Custom Flag Fields and Apply Filters

Maintenance Made Easy: Using flags instead of duplicating task rows keeps your WBS (Work Breakdown Structure) clean and makes future project schedule updates much easier to manage.

Free Microsoft Office alternative

Manage Your Projects Easily with WPS Office

If Microsoft Project feels too complex or you need a simpler way to track tasks, durations, and milestones, WPS Spreadsheet offers an excellent, lightweight alternative. You can easily build Gantt charts and project timelines using familiar spreadsheet formulas and free built-in templates.

1. Download WPS Office: Install WPS Office for free on your Windows, Mac, or Linux device.
2. Open a Project Template: Launch WPS Spreadsheet, go to the Homepage, and search for 'Project Management' in the template library.
3. Customize Your Milestones: Select a Gantt chart or milestone template to start tracking tasks, start dates, and durations without complex settings.

Free and lightweight alternative to heavy project management software.Fully compatible with Microsoft Excel (.xlsx) formats for easy sharing.Hundreds of free project management and Gantt chart templates built-in.Familiar spreadsheet interface for customizing milestone tracking without strict zero-duration rules.

microsoft office alternative - wps office

Frequently Asked Questions

Why do milestones in Microsoft Project always have zero duration?

By definition in project management, a milestone represents a significant point in time or a completed event, rather than a task that requires time to complete. Therefore, MS Project locks milestones at zero duration by default.

Can I link a predecessor task's duration directly to a milestone row?

No, Microsoft Project does not natively mirror predecessor dates or durations directly into a milestone row. You must use workarounds like custom Flag fields and filters to group these tasks in reports.

How do I create a milestone report without cluttering my WBS?

Avoid duplicating task lines to create reports. Instead, create a custom Flag field to mark the essential tasks and milestones, then apply a filter to hide the rest of the schedule. This preserves your original Work Breakdown Structure.

Office Quick Solutions