Hello,

I am trying to build a report where I look at my teams utilization and show how much they can get done in the remainder of the month and if I have given them enough tasks to fill that time.

I currently have a tasks table where I store the amount of effort per task, with start date and end date of those tasks.

I am trying to figure out how I:

1. Calculate the remaining work week working days left (i.e. right now in May we have 20 working days left).

2. Leverage my start date and end date + hours to determine if the hours applied will consume this month (OR) subsequent months.

3. Make a graph of utilization for next 3 months accordingly.

Any help would be greatly appreciated!

Andrew

------------------------------

Andrew Andrew

------------------------------