In a formula-type column, the WEEK_ADD() function displays a date obtained by adding a number of weeks to a date-type column.
-
Function name:
WEEK_ADD()
Syntax
WEEK_ADD(date_column, number_of_weeks)
Function parameter usage in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add in quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
date_column |
The date-type column to which weeks will be added. |
number_of_weeks |
The integer number of weeks to add. Positive to move the date forward, negative to move it backward. |
Example
WEEK_ADD($Date, 2)
The column returns the date shifted by 2 weeks.
The end date is the sum of the start date and the duration.
Notes
- The number of weeks can be negative: the function then moves the date backward.
Return type
The function returns a date.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output Format Options in the Formula Column article.
Business use case
WEEK_ADD() calculates deadlines in weeks: follow-up date at W+2, next weekly review, end of a trial period.
Best practice
For shifts in days, months, or years, use DATE_ADD(), MONTH_ADD(), or YEAR_ADD() respectively.