MIN_DATE

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

Function syntax

MIN_DATE(input1, ...)

Arguments:

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

Examples

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