I am still not sure what the problem is here. Click the little question mark
symbol in the Main Excel view. Type 'NETWORKDAYS' and yo will see a good
example of this this function works. Copy/paste the example into a sheet
(fills cells A1:C7), and enter this function into cell E3;
What result do you get? 108? That is correct. Look at the logic.
I renamed a sheet to Holidays and entered =TODAY() in Cell A1. in A2 I put
=A1+1 then filled down until A29. now, back to the first sheet, enter this
in cell E3: =NETWORKDAYS(B3,B4,Holidays!A1:A29)
What result do you get? You should get 88. try it. Try to adopt that for
your specific example. Post back with any additional, specific, questions.
If this information was helpful, please indicate this by clicking ''Yes''.