Skip to content

Instantly share code, notes, and snippets.

@emmaly
Created January 16, 2023 03:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save emmaly/023e5e21e722eed386fb3ee9980eae16 to your computer and use it in GitHub Desktop.
Save emmaly/023e5e21e722eed386fb3ee9980eae16 to your computer and use it in GitHub Desktop.
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