Skip to content

TechRepublic

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Project Management

How to create deadlines in Microsoft Project 2007

By Dr. Andrew Makar December 14, 2010, 12:56 AM PST

Image
1
of 6

msprojectdeadlinesfigure_1.png
msprojectdeadlinesfigure_1.png
How to create deadlines in Microsoft Project 2007

Sample project schedule

Sample project schedule

IT project teams rarely have the luxury of deciding a project’s end date. The team is usually handed a high-level scope with an expectation to deliver by the end date, while keeping project costs within a fixed budget. The end date is often based on management commitments, government mandates, political pressure, or unrealistic or unmanaged expectations.

A common reaction from project managers is to conduct a high-level analysis, provide a high-level estimate, and push back on the mandated deadline. Pushing back on a management deadline without supporting data is futile and will make you appear inexperienced. Fortunately, there is a better way to validate whether the deadline can be met. In this tutorial, I show how to create and then validate a deadline in Microsoft Project.

This TechRepublic gallery is also available as an IT Leadership blog post.

Step 1: Build a detailed project schedule
The key to validating a deadline is a realistic project schedule. Analogous and top-down estimation techniques are useful for high-level budget and duration forecasts; however, if you are going to determine whether a deadline is realistic, you’ll need a detailed project schedule.

Management will often question if all the dependencies and resource constraints have been considered, so be sure to verify that: the plan has well-defined dependencies, resources are accurately leveled, and the project calendars accurately reflect working times. At this stage in the project, you may not have all the specific resource names defined, but you should have a good idea of the number of resources and roles. This figure is a sample project schedule.

Screenshot by Dr. Andrew Makar for TechRepublic

How to create deadlines in Microsoft Project 2007

Insert Column

Insert Column

Step 2: Insert the Deadline column

To insert the Deadline column, follow these steps:

1. Click the Predecessor column or the column where you want the Deadline column to appear.

2. Select Insert | Column from the Insert menu and choose the Deadline column from the Field Name drop-down menu.

3. Click the OK button.

Screenshot by Dr. Andrew Makar for TechRepublic

How to create deadlines in Microsoft Project 2007

Deadline column

Deadline column

This figure depicts the Deadline column in the Gantt Chart view.

Screenshot by Dr. Andrew Makar for TechRepublic

How to create deadlines in Microsoft Project 2007

Select a deadline date

Select a deadline date

Step 3: Assign a deadline to the 1st level task
The first deadline you should assign is to the highest level task in the project schedule. This is usually row 1 in the project schedule, though if you have the Show Project Summary task option checked, you’ll see a row 0 in Microsoft Project. Since you can’t assign a deadline to a Project Summary task (row 0), you’ll need to turn it off by going to Tools | Options | View tab.

If the project schedule doesn’t use the View Project Summary task option, you’ll still want to ensure all the tasks in the project are indented under row 1. By indenting all the tasks under row 1 task, Microsoft Project will roll up all the finish dates to row 1. You will be assigning a project deadline to row 1, as it represents the end date of the project.

To assign the deadline, follow these steps:

1. Click the Deadline cell on the desired task.

2. Use the drop-down calendar to assign a date or enter a date manually.

Screenshot by Dr. Andrew Makar for TechRepublic

How to create deadlines in Microsoft Project 2007

Deadline in Gantt Chart

Deadline in Gantt Chart

Deadlines appear in the Gantt Chart view as an inverted green arrow. In this example, the deadline is 6/30/2011, and the current project schedule has a forecasted finish of 5/24/2011. Based on the underlying tasks, the deadline of 6/30/2011 will be met.

Screenshot by Dr. Andrew Makar for TechRepublic

How to create deadlines in Microsoft Project 2007

Missed Deadline

Missed Deadline

If the deadline can’t be met, the Indicators column will flag the tasks with a red diamond and an exclamation icon.

At this stage in project schedule development, you’ve built an initial schedule that has a deadline established for the end date. The next step is to refine the schedule and validate that the deadline can still be met.

Step 4: Refine the project schedule
Before you meet with the project sponsor requiring the deadline, you should review the schedule and refine it further to accommodate any additional risks, resource changes, duration changes, dependencies, etc. Once you have a valid project schedule that meets or exceeds the project deadline, you have enough information and proof to validate or reject the project deadline. By watching the Indicator column, you can quickly determine if a project deadline can be achieved.

Step 5: Integrate deadlines, milestones, and baselines
Deadlines can be applied to any task in the project schedule. Once you produce a valid project schedule, I recommend adding deadlines to specific milestones to represent drop dead dates. By analyzing the critical path and key milestones, additional deadlines can be defined. A deadline date doesn’t necessarily need to match a forecasted milestone or be the same as a task’s baseline finish date; a project can still miss its baseline finish date and still not miss its deadline. The Deadline column is just another tool to add a meaningful indicator into your project schedule. You still need to add the appropriate milestones and baselines to the project schedule.

Why not use the Must Finish By Constraint?
You may wonder why the project schedule should use a deadline instead of Microsoft Project’s Must Finish By Constraint. You can assign a Must Finish By Constraint to various tasks across the project schedule, but the problem with this approach is that you lose the ability to develop a dynamic schedule. By establishing a constraint-based schedule, you’ll experience constraint warning messages as you continue to refine the project schedule. You should build the project schedule to be fluid and dynamic. As the project executes, the schedule will change, and the deadline flags will provide the appropriate information without creating constraint problems during schedule development.

Conclusion
By incorporating these “requests” as deadlines in the schedule, you can competently develop a schedule that meets the deadline or provides a realistic project finish date. Once your team reviews a realistic schedule with the project sponsors, you can have meaningful scope or resource discussions that support or extend the desired deadline.

In my next TechRepublic article, I’ll show how to use multiple deadlines to manage your project schedule.

Screenshot by Dr. Andrew Makar for TechRepublic

  • Project Management
  • Account Information

    Share with Your Friends

    How to create deadlines in Microsoft Project 2007

    Your email has been sent

Share: How to create deadlines in Microsoft Project 2007
Image of Dr. Andrew Makar
By Dr. Andrew Makar
Dr. Andrew Makar is an IT program manager and is the author of How To Use Microsoft Project and Project Management Interview Questions Made Easy. For more project management advice visit http://www.tacticalprojectmanagement.com.
  • Account Information

    Contact Dr. Andrew Makar

    Your message has been sent

  • |
  • See all of Dr. Andrew's content

TechRepublic Premium

  • TechRepublic Premium

    Email/Instant Message/voicemail retention policy

    Maintaining electronic communications in business involves walking a fine line. Employees want relevant information to be kept available for future reference so that they can do their jobs, but keeping these items long-term can pose security and resource risks. Server hard drives can fill up, or stolen data (even if outdated) might pose a threat ...

    Downloads
    Published:  February 7, 2023, 11:00 AM EST Modified:  February 8, 2023, 2:00 PM EST Read More See more TechRepublic Premium
  • TechRepublic Premium

    Supplier management policy

    Information technology depends upon the acquisition of products and services for use by the business to achieve operational goals and become profitable. Building and managing productive relationships with suppliers (the description of which includes vendors) is an integral responsibility for many IT departments. Ensuring suppliers are properly vetted, negotiated with, and serve as a valuable ...

    Published:  February 7, 2023, 11:00 AM EST Modified:  February 8, 2023, 1:00 PM EST Read More See more TechRepublic Premium
  • TechRepublic Premium

    Streaming media policy

    Although there are many legitimate business reasons to access streamed audio and video files — such as engaging in training, reviewing industry-related content and conducting research — there are also opportunities for misuse. This policy provides guidelines for the appropriate use of streaming media on systems and devices that access company networks. From the policy: ...

    Published:  February 6, 2023, 11:00 AM EST Modified:  February 7, 2023, 1:00 PM EST Read More See more TechRepublic Premium
  • TechRepublic Premium

    COVID-19 workplace policy

    The COVID-19 workplace policy from TechRepublic Premium describes the procedures the organization has adopted in an attempt to minimize the spread of coronavirus infections. From the policy: Purpose The purpose of the COVID-19 workplace policy is to ensure all individuals entering organization facilities understand and abide by COVID-19 protocols. The guidelines described within this policy ...

    Published:  February 6, 2023, 11:00 AM EST Modified:  February 7, 2023, 4:00 PM EST Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice