| Line 45: |
Line 45: |
| | |} | | |} |
| | | | |
| − | =WORKDAY(A1,A2): Calculates next working day 140 days after date mentioned in A1. Weekend days are excluded. Displays '''12/12/2014''' as a result. | + | =WORKDAY(A1,A2): Calculates next working day 140 days after date mentioned in A1. <br />Weekend days are excluded. Displays '''12/12/2014''' as a result. |
| − | =WORKDAY(A1,A2,A3:A4):Calculates next working day 140 days after date mentioned in A1 and holidays in A3, A4. Weekend days are excluded. <br />Displays '''12/16/2014''' as a result. | + | =WORKDAY(A1,A2,A3:A4):Calculates next working day 140 days after date mentioned in A1 <br />and holidays in A3, A4. Weekend days are excluded. <br />Displays '''12/16/2014''' as a result. |
| − | =WORKDAY(B1,B2) : Calculates working day 30 days before the starting date mentioned in B1. Displays '''01/20/2014''' as a result. | + | =WORKDAY(B1,B2) : Calculates working day 30 days before the starting date mentioned in B1. <br />Displays '''01/20/2014''' as a result. |
| − | =WORKDAY(DATE(2013,6,1),60): Calculates next working day 60 days after mentioned date. Displays '''8/23/2013''' as a result. | + | =WORKDAY(DATE(2013,6,1),60): Calculates next working day 60 days after mentioned date. <br />Displays '''8/23/2013''' as a result. |
| | + | |
| | + | ==Related Videos== |
| | + | |
| | + | {{#ev:youtube|lr3oabjmBh0|280|center|WORKDAY}} |
| | | | |
| | == See Also == | | == See Also == |