Hello saban,

We had somewhat of a similar thread on another forum:

http://www.puremis.net/excel/cgi-bin...num=1136318939

Here's an abstract of a reply I made there, perhaps you can use it to solve your problem.

**
This function will calculate the working days between the beginning of the year and the 27th of January and will therefor result in 20.

=NETWORKDAYS(DATE(2006,1,1),DATE(2006,1,27),0)

Note that you can also use references to cells that contain a date value. For example, let's say the date 1/27/2006 you want to use is in cell A1, then you could use this formula:

=NETWORKDAYS(DATE(2006,1,1),A1,0)

Applied to your question if the translater is able to translate a document before a given deadline you could do the following. You know the number of pages to translate, they are in column C. Let's assume your data starts at row 1. The pages that the translater can translate can be calculated as follows:

=NETWORKDAYS(E1,F1,0) *6

If this number is bigger then the number pages the translater has to translate then it can be done:

=IF(NETWORKDAYS(E1,F1,0) *6 >= C1,"Yes, it can be done","No, not possible")

Hope that helps,

Rembo