Skip to content

Instantly share code, notes, and snippets.

@emmaly
Created January 16, 2023 03:12
Embed
What would you like to do?
Google Sheets Named Functions: DATEMAX and DATEMIN
=
ARRAY_CONSTRAIN(
SORT(
FILTER(
range,
MAP(
range,
LAMBDA(
cell,
ISDATE(cell)
)
)
),
1, FALSE
),
1, 1
)
=
ARRAY_CONSTRAIN(
SORT(
FILTER(
range,
MAP(
range,
LAMBDA(
cell,
ISDATE(cell)
)
)
),
1, TRUE
),
1, 1
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment