Counting networkdays with negative number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the number of days between two dates minus 1 to exclude
the start date.
Here is the formula i have with M2:M15 being my holidays.
=NETWORKDAYS(F1, G1, $M$2:$M$15)-1

My problem is when something is done early i get a negitave number and it
subtracts 1 like i told it to but i need to add one to Negative numbers.

Date due Date Complete current formula
should be
F J
1/4/2007 1/3/2007 -3
-1
1/4/2007 1/4/2007 0
0
1/4/2007 1/5/2007 1
1

Any help would be greatly appriciated.
 
Miranda,

=IF((NETWORKDAYS(F1, G1, $M$2:$M$15)-1)<0, NETWORKDAYS(F1, G1, $M$2:$M$15)+1, NETWORKDAYS(F1, G1,
$M$2:$M$15)-1)

HTH,
Bernie
MS Excel MVP
 
Back
Top