networkdays-function

[Rembo]

just one question but what if translator gets one document that he is able to translate, and meanwhile he gets another one, how to check if he is able to translate both of them??

This is actually a mathematically complicated matter. For just two assignments it can be easily solved though.

Assuming you will use a row for each assignment, you will have to add up the needed days for each of the assignments. For example, say your translater has an assigment that is listed in row 1 and another in row 3. This formula calculates the total days needed to complete his work.

=(NETWORKDAYS(E1,F1,0)+NETWORKDAYS(E3,F3,0)) *6

To set this of against the days until the deadline, you will need to look at two things.

1) You will have to verify that each of the projects can be done before it's own deadline. This is what is done in the previous message.

2) You will have to verify that the days needed to do both of the projects are less or equal then the largest number of days till the deadline of both projects.

An example:
Say assigment 1 takes 4 days to finish and assignment 2 takes 5 days to finish. The deadlines for each assignment is respectively 5 days from now and 9 days from now. In table view:

Assignment    days needed     days till deadline
1			4		   5
2			5		   9

1) Each of the assignments can be finished before their own deadline because 4<=5 and 5<=9

2) Days needed for both assignments is 4+5 = 9 days. Max of days till deadline is also 9 days. 9<=9 so the answer is yes, it can be done.

Rembo