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

Formula

WEEK_ADD(Colonne date, Nombre X)

Or

WEEK_ADD(Colonne date, Colonne semaine)

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

The second parameter is either :

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

Example

WEEK_ADD(Début,{Durée (semaines)})

Configurator

Résultat

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