Forum Discussion
ajl_ahmed
Aug 05, 2024Iron Contributor
Selecting the three dates after specific date
Hi
I want to select the first three dates after the specific date. Is there formula do that? see the attached file
Thx.
SQL:
create temp table aa as
select udf_my_date_format(f01) d,* from Sheet1 ;
select f01 from aa where d>'2023-05/26' order by d desc limit 3;
4 Replies
Sort By
- peiyezhuBronze Contributor
SQL:
create temp table aa as
select udf_my_date_format(f01) d,* from Sheet1 ;
select f01 from aa where d>'2023-05/26' order by d desc limit 3; - Patrick2788Silver Contributor
Another variant into the hopper:
=LET( filtered, SORT(FILTER(ListA, ListA > F5, "none"), , -1), TAKE(filtered, -3) )
- m_tarlerBronze Contributor
ajl_ahmed try:
=IFERROR(INDEX(C7:C13,{-2;-1;0}+MATCH(F5,C7:C13,-1)),"")
probably could have used some of the new formulas but I this works
actually this works a little better:
=TAKE(TAKE(C7:C13,MATCH(F5,C7:C13,-1)),-3)
because it behaves better when you are at the top of the list and only 1 or 2 are valid
both are shown in the attached for comparison