AddDate() function

AddDate() function

AddDate(argument list…)

Adds or subtracts from a base date by a user-specified number of years, quarters, months, weeks, and/or days, in that order. Non-integer values are rounded by the function to the nearest integer. The function uses the following arguments:

Argument	Description	Restrictions
Base_Date	starting date	valid Excel date number
Years	years to add to Base_Date	integer value
Quarters	quarters to add to Base_Date	integer value
Months	months to add to Base_Date	integer value
Weeks	weeks to add to Base_Date	integer value
Days	days to add to Base_Date	integer value