Forum Discussion

AndrewWilber's avatar
AndrewWilber
Qrew Trainee
5 years ago

Working days left in the month

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
------------------------------
No RepliesBe the first to reply