Changes

no edit summary
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 ==
writer
2,661

edits