MAXDATE

MAXDATE returns the latest date available in the column header.

Example

In this report, we have historical data from 2024 and a forecast for 2025 until March. The MAXDATE function returns the latest date available in the report - March 31st, 2025.

MAXDATE