Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to show which projects go over which quarters

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

How to show which projects go over which quarters

Resolved · High Priority · Version 2010

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

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

Excel articles

· Excel Macros for the Non-Programmer
· Basic Excel Training
· Using Excel In Any Condition
· Tracking In Excel 2003
· Copy And Paste In Excel

Please browse our web site to find out more about
microsoft excel training in london and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips