Setting a start date for project data in excel

sarah vallance

New Member
Joined
Apr 6, 2011
Messages
1
Hi there,

I am programming a project portfolio spreadsheet for resource management and my boss wants to programme in start dates for projects.

This means that the resource usage data for that project will start at the corresponding time in the spread sheet.

For example we use quarters, Q1, Q2, Q3, and Q4. I would like to be able to set a project to show its data fron Q3 onward.

Is there any possible way of doing that??

Thanks
sarah
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
Hello and welcome to The Board.
It depends on how the data is organised. If done correctly then it should be possible - perhaps a pivot table will give you what you want.
If you can give more detail about how the data is set out and the version of Excel that is being used, someone may be able to give you some ideas.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,991
Messages
5,526,105
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top