98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Calculation Periods and Duration from start and end dates
Calculation Periods and Duration from start and end dates
Resolved · Low Priority · Version 2010
julia has attended:
Project Advanced course
Calculation Periods and Duration from start and end dates
As the timeline in Project 2013 is restrictive when dealing with lots of Gantt lines (I have 64 initiatives in this portfolio), I would like to use the Visual Reporting to provide information that I can plug into the Excel Project Gantt Planner template. In that Excel Project Gantt planner, I need to calculate start dates and time in MSP into periods – which I am happy to do (if I knew how to do it). So I need to customise a column, using a formula to calculate.
1.
Plan Start Period Number
Assumption P1 is the first week in 2016
Formula: Look at base line date and assign the start period, e.g. 4/1/16 is P1
2.
Plan duration number of periods
Formula: Look at the baseline start date and baseline end date and calculate how many periods, e.g. statt4/1/16, finish 15/1/16 number of periods = 2
I will 2 other calculations e.g. Actual Start and Actual Duration, but I will be able to work those out form the formulas above.
Many thanks.
RE: Calculation Periods and Duration from start and end dates
Hi Julia,
This is a very good question.
While we can do lookups (Drop downs) using custom Fields we can not use the Vlookup function from Excel.
I think I'm aware of the Excel Gantt Planner you are referring to.
Once I've Exported/Copied the Project Data into Excel, I would write a Vlookup to pull the Period number from a date table.
I've attached an Excel File with an example lookup so you
can "Convert" the data into Periods/Weeks
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Wed 7 Sep 2016: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Set default task type - Project 2010a. In Project, click on the File tab |