DateAdd(interval, number, date) returns a Variant/Date containing the date of the specified interval after the specified date : DateAdd « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. DateAdd

DateAdd(interval, number, date) returns a Variant/Date containing the date of the specified interval after the specified date

 
Sub dateDemo2()
    Debug.Print DateAdd("m", 1, "6/3/06"); returns; 7 / 3 / 2006#
End Sub








Related examples in the same category

1.DateAdd returns the result of adding or subtracting a specified period of time to a date:
2.Add value to Date