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.