DATE_ADD() : add or subtract days from a date

In a formula column, the DATE_ADD() function displays a date obtained by adding a number of days to a date column. It is handy to calculate a due date or a follow-up date. The result is a date.

Syntax

DATE_ADD(date_column, number_of_days)

Parameters

# Parameter Description

1 date_column The Date column to add days to.

2 number_of_days The whole number of days to add. Positive to move the date forward, negative to move it back.

Examples

Move a date forward

To add 3 days to a quote sending date:

DATE_ADD($Quote sent, 3)

Move a date back

To move a delivery date back by 4 days, use a negative number:

DATE_ADD($Customer delivery, -4)

Calculate a one-year due date (+365 days)

To calculate a due date one year after a signature date:

DATE_ADD($Signature date, 365)

For an exact calendar span (accounting for leap years), prefer YEAR_ADD($Signature date, 1).

Your formula returns 0 or stays empty

The source column is not a Date column

The first parameter must be a Date column. Empty or filled with another value type, the function has nothing to calculate from.

The column output format is not Date

In the Options tab, set the output format to Date. For details, see Output format options in the Formula column article.

Go further

DATE_ADDNB

When the number of days to add varies per record and is already stored in a column, rather than a fixed value.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.