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
>I am trying to get the number of days between two dates minus 1 to exclude > the start date. [quoted text clipped - 15 lines] > > Any help would be greatly appriciated.