1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. ADDMONTHS

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

DATE

Back to Top

Example

ADDMONTHS(x, n) 

x = 06/25/2017

n = 6

Result = 12/25/2017

Back to Top

Similar functions