Navraj has attended:
Project Intro Intermediate course
How to show which projects go over which quarters
Hi,
I am setting up a summary sheet using Excel and i want to show what projects occur during which quarter.
For example:
If i had a project that started 1st Jan and finished 1st June I would want the summary sheet to show that the project runs over Q1, Q2 and Q3.
Is their anyway of doing this?
This is example data i would be using:
Project Nam Start Date End Date
Project 1 01/10/2011 11/02/2011
Project 2 01/10/2011 01/12/2011
Project 3 01/10/2011 01/12/2011
Thansk in advance,
Nav
RE: How to show which projects go over which quarters
Hello Navraj,
Thank you for your question regarding how to show the quarters a project may run over.
You need to provide me with more detailed information. Firstly, you say that if you have a project starting 1st Jan finishing 1st June the project runs over Q1, Q2 and Q3. How is this possible since Q3 only begins on 1st July.
I presume you mean that if a project ends in the middle of a quarter it is counted as running over that quarter?
If you also provided me with a sample worksheet and an explanation as to why you need this requirement it will help.
Send to: rl@stl-training.co.uk
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
