Calculate Days Worked Each Month

[Darren_S15]

I am generating a report from MS Project 2007 in Excel showing each
task the number of days worked on it.

Each task only has one resource associated with it, although this may
have no relevance.

What I am trying to do is calculate the total number of days each task
is worked on per month.

So in Excel I would have for example October2009, November2009,
December2009 etc in the columns.

Then on the rows below a list of how many days this task has been
worked on this month.

I have searched the web and books and cannot find any easy way to do
this without writing my own modules.

Does anyone know of a solution to this?

Thanks,
Darren

 

[Mike Glen]

Hi Darren,

Welcome to this Microsoft Project newsgroup

Have you had a look at the Task Usage view? You can zoom in to Months and
see the Work done per month. If you want this in days rather than hours,
Tools/Options/Schedule tab and select accordingly.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Darren_S15]

Hi Mike,

Many thanks for your reply.

I have had a look through the stuff you posted

The view you mention is certainly along the lines of what I need yes.

Is there a way I can access task usage information through vba?

What Im after is working out how many working days there are between
task start and task finish dates ideally.

Ive started writing my own code to do this but wondered if there is
anything existing I could use.

Thanks,
Darren

 

[Rob Schneider]

You can access task usage data via VBA ... see Help.

Or ... just create a new custom number field that subtracts the
difference between the start/finish date for the task using either the
function ProjDateDiff() or DateDiff() ... the former computes working
days difference and the altter computes calendar day differences. See
Menu: Tools/Customise/Fields ... Help buttons are on the pages which
should guide you.

--rms

www.rmschneider.com

 

[Mike Glen]

You're welcome, Darren

I'm not a vba guru, try posting on the microsoft.public.project.developer
newsgroup (forum). Please see FAQ Item: 24. Project Newsgroups. FAQs,
companion products and other useful Project information can be seen at this
web address: http://project.mvps.org/faqs.htm

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Darren_S15]

Quick update.

I managed to do this in vba in the end.

The solution was to use ActiveProject.Calendar.Years(x) to walk
through the year.

This then has a .Months(x) a .Days(x) option.

From these you can get .Count to give you a total count of months in a
year (used on for loops) or days in a month.

The final part is .Days.Working = True indicates if the day in
question is a working day or not.

Using a combination of the above you can work out all the working days
between two dates.

Hope this is useful to someone else someday.

Thanks to those who helped me.

Darren