Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting networkdays with negative number
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting networkdays with negative number
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 "Miranda" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
change negative sign from end of the number to the begining | Excel Discussion (Misc queries) | |||
Counting number of cells that make up a sum.. | Excel Discussion (Misc queries) | |||
Force function to show positive or negative number? | Excel Worksheet Functions | |||
convert cells to negative number | Excel Discussion (Misc queries) |