ADDMONTHS

The ADDMONTHS function adds or subtracts a specified number of months from a date. This function is commonly used to calculate future or past dates based on monthly intervals.

Syntax

ADDMONTHS(date, value)

Arguments

• date: The input date. This can be a date value, measure, or reference.

• value: The number of months to add or subtract. Use a negative value to subtract months.

Return value

Returns the calculated date.

Examples

ADDMONTHS("05/29/2024", -2)

Returns 03/29/2024 by subtracting 2 months from the input date.

ADDMONTHS("05/29/2026", 3)

Returns 08/29/2026 by adding 3 months to the input date.