ADDDATE function adds a given number of days to a date.
|The date to add/subtract from
|The number of days to add or subtract
number_of_days is negative, then
ADDDATE can be used to subtract from the given
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:
The number of days could also be a function of the urgency of the case:
ADDDATE(CASE_OPEN_DATE, IF(Urgency.High, 7, 14))