Description
The ADDDATE function adds a given number of days to a date.
Usage
ADDDATE(date, number_of_days)
| Argument | Type | Required | Description |
|---|---|---|---|
| date | date | Yes | The date to add/subtract from |
| number_of_days | number | Yes | The number of days to add or subtract |
If number_of_days is negative, then ADDDATE can be used to subtract from the given date.
Examples
Calculating a deadline
If you have a form for managing emergency cases, you may want to calculate a deadline for taking action based on the date the case was opened:
ADDDATE(CASE_OPEN_DATE, 14)
The number of days could also be a function of the urgency of the case:
ADDDATE(CASE_OPEN_DATE, IF(Urgency.High, 7, 14))