Oct 28 2021 09:36 PM
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.
Oct 29 2021 03:32 AM
Don't forget to change the cell format in percent. Example file inserted.
=(TODAY()-D2)/(E2-D2)
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Oct 29 2021 05:12 AM
@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 :)
Oct 29 2021 10:52 AM
Oct 30 2021 09:26 PM - edited Oct 30 2021 09:31 PM