ADDQTRS

The ADDQTRS function adds or subtracts a specified number of quarters from a date. It is commonly used to calculate future or past quarter-based reporting periods.

Syntax

ADDQTRS(date, value)

Arguments

• date: The input date. This can be a date value, measure, or reference.
• value: The number of quarters to add or subtract. Use a negative value to subtract quarters.

Return value

Returns the calculated date.

Examples

ADDQTRS("05/29/2024", -1)

Returns 02/29/2024 by subtracting 1 quarter (3 months) from the input date.

ADDQTRS("05/29/2026", 2)

Returns 11/29/2026 by adding 2 quarters (6 months) to the input date.