Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of working days between 2 dates
So I've seen similar posts; however, no solutions to this problem.
Using the networkdays formula, I calculated the number of working days between the due date and the completed date... =NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18) where K1=Date Complete (5/1/07) G1=Due Date (5/1/07) I would think the result of the formula would = 0, since the due date and date complete are the same. Instead, the result is 1. Any suggestions how I can count the number of days in between the 2 dates to reflect Days Early/Late? Thanks in advance for your help. -T |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of working days between 2 dates
A couple of thoughts............if you want your formula to result in zero
when both dates are the same, try =NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18)-1 or maybe just put =G1 as one of your holidays.... hth Vaya con Dios, Chuck, CABGx3 " wrote: So I've seen similar posts; however, no solutions to this problem. Using the networkdays formula, I calculated the number of working days between the due date and the completed date... =NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18) where K1=Date Complete (5/1/07) G1=Due Date (5/1/07) I would think the result of the formula would = 0, since the due date and date complete are the same. Instead, the result is 1. Any suggestions how I can count the number of days in between the 2 dates to reflect Days Early/Late? Thanks in advance for your help. -T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates calculation using working days | Excel Discussion (Misc queries) | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
adding only working days to dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions |