MAX Function

Returns the highest number or latest date.
Sample Usage
MAX(Cost1:Cost5)
Syntax
MAX(
  • value1
  • [
    • value2
    • ...
    ]
)
  • value1
    The number or range from which you want the highest value.
    • value2
    • ...
    —[optional]
    Additional numbers or ranges.
Usage Notes
  • When referencing dates, you must use MAX in a Date column. See Column Types for more information on Date columns.
     
Was this article helpful?
YesNo