Excel Project Planning Spreadsheet Updated Version 3

*** Updated 11/2014 ***

Be sure to check out the updated version of this template.

This article builds on a previous post which covers Project Planning leveraging Microsoft Excel

Some users of the Microsoft Excel Project Planning Spreadsheet Template expressed trouble modifying the date ranges when customizing the template. To make this process a bit easier, I’ve updated the project planning template to automatically show the day of the week in cell H3 based on the date value entered in cell H2. So to be clear, the process of customizing this spreadsheet should begin with modifying the date value in cell H2. Once you’ve entered the first date you want to show in the gantt view in cell H2, simply click and drag to expand the dates horizontally in row 2.

Once you’ve edited the date ranges for the gantt view, you can move over to the task list and begin entering the tasks in your work breakdown and the associated dates for each task.

The spreadsheet will automatically block out weekends and display the gantt bars according to the length of the tasks you enter. The gantt bars will automatically change color based on the progress you enter in column F from 0 to 100%. If progress is less than 50% and the current date has passed the projected end date for a task, the gantt bar will change to RED. Once the task is complete, the gantt bar will change to GREEN.

Here’s a link to download the updated project planning template:

Download “Excel Project Plan v3” MS-Excel-Project-Plan-Template-v3.xlsx.zip – Downloaded 16009 times – 47 KB

Using this spreadsheet is fairly easy and straight-forward but if you have suggestions that may improve usability, please leave a comment below.


6 Replies to “Excel Project Planning Spreadsheet Updated Version 3”

    1. I know this post is old, but I’m an Excel project planning fan. At least to start my projects off. Anyhow, I was having the same issue when downloading. All conditional formatting on the gaant weren’t showing up. The only formatting was days in\out of project. All other rules weren’t even there, disappeared.
      That was using Excel 2007.

      I then tried opening the same file in Excel 2010 and all conditional formatting came over fine.

      So, without too much investigation, I’m assuming there are some formulas used in those rules that aren’t available in 2007 and are being stripped out when you open it. Open it in a newer version of Excel and all features should come through.

  1. Hi Mike,

    thanks a lot for the great tool, it is a big help for my work.

    I have two questions for which I didn’t find a solution, I hope you have time to answer them.

    a) The weekends are blocked at the moment, is there a way to change that?
    b) I want to use different colors for the gantt bars (don’t use the progress column and the green/red status signal) –> Is there a simple way to change the bar colors according to my needs (e. g. green for project stream xy, black for project stream xyz etc. )?

    Thanks a a lot


  2. Great tool. I love, I have 2 questions and I hope you can answer them for me.
    1) I have modify the range to monthly instead of weekly but I have 2 month that are shade as if they are week end. How can I fix that?
    2) Can I customoze the display color to make it specific to my project?

Leave a Reply

Your email address will not be published. Required fields are marked *