writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 47:
Line 47: + + + +
no edit summary
=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(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. <br />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.
==Related Videos==
{{#ev:youtube|ZsT7i1Ckc6c|280|center|NETWORKDAYS}}
== See Also ==
== See Also ==