|re: "Your first NETWORKDAYS has a brace missing..."|
I guess it depends on how you look at it. mosaddique feels there is a brace (parenthesis) missing, and I feel that there are 3 too many.
The Help file for NETWORKDAYS show this syntax:
There are no parenthesis around the start_date or end_date.
mosaddique feels it should look like this:
I feel it should look like this:
The same holds for your IF functions. You don't need parenthesis around the arguments/cell references within the IF function.
As I said in Response #1, you have way too many unnecessary parenthesis which makes your formula very hard to read.
Posting Tip: Before posting Data or VBA Code, read this How-To.