Skip to content
Adaptam Docs

MAX_DATE

Maximum (latest) date value in cells, ranges, or data fields. Non-date values (text, numbers, blanks/empty cells, Booleans, errors) are ignored.

Function syntax

MAX_DATE(input1, ...)

Arguments:

  • input1, …: One or more dates, cells, ranges, or data fields.

Examples

  • MAX_DATE(A1:A3) - If A1:A3 contains 3/15/24, 1/5/24, 2/20/24, returns 3/15/24.
  • MAX_DATE(order_date{}) - Latest value in the order_date field.
  • MAX_DATE(ship_date{region{“West”}}) - Latest ship_date where region is West.
  • MAX_DATE(order_date{}, A1:A10) - Latest date across the order_date field and cells A1:A10 combined.
  • MAX_DATE(A1:A4) - If A1:A4 contains 3/15/24, 1/5/24, TBD, 2/20/24, returns 3/15/24. Text is ignored.