Hello...

I have a dilemma that I may be making harder than it needs to be. I
have a spreadsheet with 3 columns, contain 3 specific dates. What I
need to do is to compare these columns, and calculate the NETWORKDAYS
between dates. The problem is this: If column C is blank, then I want
the NETWORKDAYS between columns A and B. If column C is filled, I want
the NETWORKDAYS between columns A and C. I can get either the first
sequence or the second sequence to work fine, but not both at the same
time. My main issue I believe is when calculating the NETWORKDAYS...
If column A is larger than column B, no problem. But if column B is
larger than column A, it returns a negative value, which is what I
want, but the calculation is off. Below is the date I am using...

SLA Date Production Date Deliverable Date Net-Work Days SLA Made by
03/10/06 03/03/06 5
03/08/06 03/09/06 -1
03/09/06 03/09/06 0
03/15/06 03/09/06 03/22/06 FALSE

=IF(F6="",IF(E6<D6,NETWORKDAYS(E6,D6,$M$6:$M$14)-1,IF(E6>D6,NETWORKDAYS(E6,D6,$M$6:$M$14)+1,IF(E6=D6,NETWORKDAYS(E6,D6,$M$6:$M$14)-1))))

The problem is that the formula I use above works great, until column C
is populated, and then I get a FALSE return due to my IF(F6=""
statement (F6 is the deliverable date column in the example above). Is
there an easier way to account for both this column being blank and/or
filled?

Thanks ahead of time for any help.