The VBA DATEADD Function

Related Function:

VBA DateDiff

Description

The VBA DateAdd Function adds a time interval to a supplied date and/or time, and returns the resulting date/time.

The syntax of the DateAdd function is:

Dateadd( Interval, Number, Date )

Where the function arguments are:

Interval

A string specifying the interval to be used. This can have any of the following values:

"d"	-	Days
"h"	-	Hours
"n"	-	Minutes
"m"	-	Months
"q"	-	Quarters (of a Year)
"s"	-	Seconds
"ww"	-	Weeks
"yyyy"	-	Years

Number

The number of intervals to add to the specified Date.

Date

The original date/time that you want to add the specified number of intervals to.

VBA DateAdd Function Examples

Example 1

' Add 32 days to the date 11/29/2015

								Dim oldDate As Date

								Dim newDate As Date

								oldDate = #11/29/2015#

								newDate = DateAdd( "d", 32, oldDate )

' newDate is now set to the date 12/31/2015

In the above example, the DateAdd function adds 32 days to the date 11/29/2015, and returns the date 12/31/2015.

Example 2

' Calculate date and time that is 27 hours after 9:00 AM on 11/29/2015

								Dim oldDate As Date

								Dim newDate As Date

								oldDate = #11/29/2015 9:00:00 AM#

								newDate = DateAdd( "h", 27, oldDate )

' newDate is now set to the date and time 11/30/2015 12:00:00 PM

In the above example, the VBA DateAdd function adds 27 hours to the date and time 11/29/2015 9:00:00 AM, and returns the result 11/30/2015 12:00:00 PM.

Example 3

' Calculate date that is 3 months after 12/31/2015

								Dim oldDate As Date

								Dim newDate As Date

								oldDate = #12/31/2015#

								newDate = DateAdd( "m", 3, oldDate )

' newDate is now set to the date 3/31/2016

In the above example, the VBA DateAdd function adds 3 months to the date 12/31/2015, and returns the resulting date 3/31/2016.

Return to the VBA Functions Page
Return to the Excel VBA Tutorial Page