Add value to Date : DateAdd « Date Functions « VBA / Excel / Access / Word






Add value to Date

 
Sub AddADay()
    Dim dtInitialDate As Date
    dtInitialDate = DateAdd("d", 1, dtInitialDate)
    Debug.Print dtInitialDate
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.DateAdd(interval, number, date) returns a Variant/Date containing the date of the specified interval after the specified date