title: Syntax of DateAdd
body: <p>I am trying to use Excel the DateAdd function to find <strong>the next working day</strong>.</p>
  
  <p>It provides the same result whether you use d, w or y for the period argument.</p>
  
  <p>I tried the following code, and get identical results in all 3 columns.</p>
  
  <pre><code>Sub test()
      Dim i As Integer
      For i = 1 To 9
          Debug.Print i;
          Debug.Print DateAdd("d", i, #9/10/2009#);
          Debug.Print DateAdd("w", i, #9/10/2009#);
          Debug.Print DateAdd("y", i, #9/10/2009#)
      Next i
  End Sub
  </code></pre>
  
  <p>Result:<br>
      1 11/09/2009 11/09/2009 11/09/2009<br>
      2 12/09/2009 12/09/2009 12/09/2009<br>
      3 13/09/2009 13/09/2009 13/09/2009<br>
      4 14/09/2009 14/09/2009 14/09/2009<br>
      5 15/09/2009 15/09/2009 15/09/2009<br>
      6 16/09/2009 16/09/2009 16/09/2009<br>
      7 17/09/2009 17/09/2009 17/09/2009<br>
      8 18/09/2009 18/09/2009 18/09/2009<br>
      9 19/09/2009 19/09/2009 19/09/2009 </p>
  
  <p>Extract from the documentation:
      Returns a Variant (Date) containing a date to which a specified time interval has been added.  </p>
  
  <pre><code>Syntax  
  DateAdd(interval, number, date)  
  ...  
  interval Required. String expression that is the interval of time you want to add.   
  ....  
  
  The interval argument has these settings:  
  
  Setting Description   
  yyyy Year   
  q Quarter   
  m Month   
  y Day of year   
  d Day   
  w Weekday   
  ww Week   
  ...  
  </code></pre>