Changes

|}

|}

  =NETWORKDAYS(A1,A2): Calculates working days in the range of cells A1 and A2. Weekend days are excluded. Displays '''42''' as a result.

  =NETWORKDAYS(A1,A2): Calculates working days in the range of cells A1 and A2. Weekend days are excluded. <br />Displays '''42''' as a result.

  =NETWORKDAYS(A1,A2,A3): Calculates working days in the range of cells A1 and A2 and a holiday in A3. Weekend days are excluded. <br />Displays '''41''' as a result.

  =NETWORKDAYS(A1,A2,A3): Calculates working days in the range of cells A1 and A2 and a holiday in A3. <br />Weekend days are excluded. Displays '''41''' as a result.

  =NETWORKDAYS(A1,A2,A3:A4):Calculates working days in the range of cells A1 and A2 and holidays in A3, A4. Weekend days are excluded. <br />A4 is ovelapped with weekend day. Displays '''41''' as a result.

  =NETWORKDAYS(A1,A2,A3:A4):Calculates working days in the range of cells A1 and A2 and holidays in A3, A4. <br />Weekend days are excluded, A4 is overlapped with weekend day. Displays '''41''' as a result.

  =NETWORKDAYS(DATE(2012,6,1),DATE(2012,12,31)): Calculates working days between two mentioned dates. Displays '''152''' as a result.

  =NETWORKDAYS(DATE(2012,6,1),DATE(2012,12,31)): Calculates working days between two mentioned dates. <br />Displays '''152''' as a result.

== See Also ==

== See Also ==