ADDDAYS

The ADDDAYS function adds or subtracts a specified number of days from a date. The input date can be in any supported date format. This function is commonly used to calculate deadlines, due dates, and future or past dates.

Syntax

ADDDAYS(date, value)

Arguments

• date: The input date. This can also be a measure or reference.
• value: The number of days to add or subtract. Use a positive value to add days and a negative value to subtract days.

Return value

Returns the calculated date.

Examples

ADDDAYS("05/29/2026", -5)

Returns 05/24/2026.

ADDDAYS("05/29/2026", 10)

Returns 06/08/2026.