Counting networkdays with negative number

M

Miranda

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.
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top