Distribute/Allocate working days of the month accross multiple projects.

**MuchieMac** · 04-25-2016, 07:43 AM

Hi all

I need to ditribute/allocate the working days of a month accross multiple projects? any help would be appreciated.

Basically the end user will plan the the projects resources by allocating a % to each project which will return the number of days that resource will work on each project, however i need this not to exceed the number of working days in that particular month (May=23 days). At the monent if i allocated 25% to each project it will return 6 days for each project (24 days) however i need 23 days (max) to be split amongst the 4 projects so that each project which would return 5.75 days.

To be honest im not sure if the above is the better approach or if it would be better to somehow distribute 100% accross the 4 projects i.e. Max 25% on each project, either way, PLEASE HELP... :-)

**CAntosh** · 04-25-2016, 01:04 PM

It would be helpful if you could post a small sample workbook (use Go Advanced > Manage Attachments), but based on what you've posted, it sounds like the NETWORKDAYS function would be helpful.
If your start date (May 1) is in A1 and your end date (May 31) is in B1, then the formula below will return the workdays in between. Divide it by 4 to get the days per project.

=NETWORKDAYS(A1,B1+1)

**MuchieMac** · 04-27-2016, 04:30 AM

Hi Cantosh

Thanks for the response.

Please see attached the sample book as requested. Hopefully this will makes things a bit clearer as to what i am trying to achieve.

Look forward to your feedback.

Many thanks