Between a start date and the next closest date of a series

[Jorge_Carreon]

Hello everyone, I’m trying filter data in a series of date that start from any given date to the next closest date. For example, in a set of dates of 7 july, 10 aug, 12 sept, 15 dec, I need to filter data only between the start date of 7 july and the next closest of 10 aug, (excluding data from 10 aug to 15 dec.) The dates variables, and are not hard coded.

In Sheets, I use something like a combination of Lookup, MAX and Filters:

=ArrayFormula(vlookup(MAX(if(FILTER($K$3:$P$36,$J$3:$J$36=B4)<=H4,FILTER($K$3:$P$36,$J$3:$J$36=B4))),FILTER($K$3:$P$36,$J$3:$J$36=B4),{3,4,5,6},0))

What’s the equivalent in Appsheet?

Any solution or clue will be greatly appreciated!

Jorge