Function MAX()

 

Description
Returns the maximum value from an array of numbers or dates.

Syntax

MAX(values)

Parameters

• values – An array of numbers or dates

Return Value
NUMBER or DATE

 

Examples

Formula

MAX([1,2,3,4,5,6])

Result
6

Formula

MAX([DATE(2019,01,01), DATE(2019,01,02)])

Result
02 Jan 2019

Notes

• Works with numeric and date arrays only
• Returns the highest value in the array