Add a specified number of months to a date. Date format depends on your locale.
To add days, add a number to the date in a date-formatted field holding the function.
Syntax
ADDMONTHS(x, n)
where
- x : date
- n : number of months to add
Format
| Input Format | Output Format |
|---|---|
|
x: Date n: Number |
Date |
Arguments
The function uses the following arguments:
- x: Date - Hard-coded date, date variable, or line item
- n: Number - Numeric line item, property, or expression
Constraints
The function has the following constraints:
- Argument x must be a date.
- Argument n must be a number.
- The result must be dates.
- Date format depends on your locale.
Excel equivalent
Example
ADDMONTHS(x, n)
x = 06/25/2017
n = 6
Result = 12/25/2017