AndrewWilber
5 years agoQrew Trainee
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
------------------------------
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
------------------------------