Data Type: String
An expression denoting the interval of time you need to add or subtract (see the following table “Interval Settings”).
Data Type: Any numeric type
An expression denoting the number of time intervals you want to add or subtract.
Data Type: Date
The date on which to base the
Day of year
Returns a Date representing the result of adding or subtracting a given number of time periods to or from a given date or time. For instance, you can calculate the date 178 months before today’s date, or the date and time 12,789 minutes from now.
Specify the interval value as a string enclosed in
quotation marks (e.g.,
number is positive, the
result will be after
number is negative, the result will
The DateAdd function has a built-in calendar algorithm to prevent it from returning an invalid date. For example, if you add 10 minutes to 31 December 1999 23:55, DateAdd automatically recalculates all elements of the date to return a valid date—in this case, 1 January 2000 00:05. In addition, the calendar algorithm takes the presence of 29 February into account for leap years.
Dim lNoOfIntervals lNoOfIntervals = 100 Msgbox DateAdd("d", lNoOfIntervals, Now)