ADDDATE

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))
Next item
AVERAGE