98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to show which projects go over which quarters | Excel forum
How to show which projects go over which quarters | Excel forum
Resolved · High Priority · Version 2010
Thu 3 Nov 2011, 16:30Delegate Navraj said...
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
Fri 4 Nov 2011, 18:28Trainer Rodney said...
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
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. |
Excel tip:Sorting data stored in rowsPrimarily Excel is set up to sort data that is stored in columns rather than rows. |
