writer
2,661
edits
Changes
Manuals/calci/NETWORKDAYS (view source)
Revision as of 21:47, 25 January 2014
, 21:47, 25 January 2014no edit summary
=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. 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. Weekend days are excluded. <br />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. A4 ovelapped with weekend day. <br />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(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. Displays '''152''' as a result.