Count number of tasks in one week?

L

-Laura

I have a huge timline created for 2007 and I need to count how many tasks I
have occuring for each week of the year. Example; wk of 2/18/07 = 7 tasks.
Can anyone help me out?
 
J

Jack Dahlgren

What do you mean by "occuring"? Do you mean starting that week or on-going
during that week? If it is on-going then there is not a simple way in
Project to do this. You can definitely filter to show active tasks during a
time frame, but you would need to do this 52 times. You could automate it
using VBA and it wouldn't be too hard, but I think the simplest way is to
export the file to Excel. All you need to export is the task name, start and
finish.

Once you have that data, set up columns for each week. This is simple, put
the finish date of the first workweek in one column, then for the next
column you can just add 7 to it and drag that formula out for the rest of
the 52 columns you need.

Once you have the column headers and the data use a formula in each cell to
count the tasks
I'd use a formula which looks at the date in the column header. If the start
is less than the column header and the finish is after the previous column
header then the task is active.

Use an if function to put a value if the task is active and then sum the
columns.

It sounds complicated but it is rather simple. I have an example very
similar to what you are asking here:

http://masamiki.com/project/Excel.htm

If you are still having trouble let me know and I'll update the example with
what you need. It really takes less time to do it than it does to describe.

-Jack Dahlgren
http://zo-d.com/blog
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top