Calculate the workload percentage

Occasional Contributor

I am thinkin about one case, to how calculate workload of employee by calculating difference between start date and estimated completion date; and statuses (for example from start to end one of 5).
By this two or more criteria calculate the workload of each employee.
Sample table below. 

4 Replies


Don't forget to change the cell format in percent. Example file inserted.



I would be happy to know if I could help.



I know I don't know anything (Socrates)


Was the answer useful? Mark them as helpful!

This will help all forum participants.

@NikolinoDE thanks, but it calculates percentage only by difference between dates. I want to include criteria statuses, to adjust value for each status like start=1%, review=40%, finished=100%.
Something like this, may be you got my vision

With your permission, if you have a vision, please put it in the file.
Before that, should the 1% come at the start?
With the existing formula depending on the date, the percentage value also changes.
However, please describe your vision step by step and if possible please also indicate in the file what your vision should look like for you.

Thank you for your patience and understanding.