DATE_ADDNB() : add a number of days (number column) to a date

In a formula column, the DATE_ADDNB() function displays a date obtained by adding, to a date column, the number of days held in a whole number column. The result is a date.

The key point: the initial date counts as a full day. DATE_ADDNB(10/10, 3) returns 12/10 (10/10 counts as the first day). The result is therefore one day off compared with DATE_ADD(), which does not include the starting date in the count.

Syntax

DATE_ADDNB(date_column, number_column)

Parameters

# Parameter Description

1 date_column The Date column used as the starting point.

2 number_column The whole number column indicating how many days to add. Positive to move the date forward, negative to move it back.

Examples

Calculate a reminder date

From a last meeting date and a delay stored in a column, TimeTonic adds that number of days to return the reminder date.

DATE_ADDNB($Last meeting, $Reminder)

Your formula returns 0 or stays empty

The result looks off by one day

This is expected: the initial date counts as the first day. Use DATE_ADD() if you do not want that offset.

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_ADD

For a strict day offset, without counting the starting date.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.