In a formula column, the function MONTH_ADD() is the addition of a date from a date column and a number X either constant or from an integer column that represents the number of weeks.

Formula

MONTH_ADD(Colonne date, Nombre X)

Or

MONTH_ADD(Colonne date, Colonne mois)

The first parameter is the exact name of a date column.

The second parameter is either :

• An integer that corresponds to the number of months I want to add. This number can be positive or negative.
• The exact name of a column of type integer.

Example

MONTH_ADD(Début,{Durée (mois)})

Configurator

Result

The end date is the sum of the start date and the duration.