DATE_ADDNB ()

In a column of type formula, the DATE_ADDNB() function displays a date that is the addition of a date from a column of type date and another column of type integer. The formula counts the initial date as a full day and therefore enters the calculation formula. 

For example, if my initial date is 10/10/19 and I want to add 3 days to it, I would have as result: 12/10/19

Formula

DATE_ADDNB(Date column,Integer column)

The first parameter is the exact name of a date column.

The second parameter is the exact name of an integer column that corresponds to the number of days I want to add. This number can be positive or negative.

Example

DATE_ADDNB(Last meeting column, Recall column)

Configurator

Depending on the value I put in the Recall D+ column, TimeTonic automatically added the value of the Recall Date column.

Result