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. Continue reading “Excel Project Planning Spreadsheet Updated Version 3”