ajl_ahmedIron ContributorAug 05, 2024SolvedSelecting 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. Book14.xlsx10 KBpeiyezhuAug 06, 2024ajl_ahmed SQL:create temp table aa asselect udf_my_date_format(f01) d,* from Sheet1 ;select f01 from aa where d>'2023-05/26' order by d desc limit 3;
peiyezhuAug 06, 2024ajl_ahmed SQL:create temp table aa asselect udf_my_date_format(f01) d,* from Sheet1 ;select f01 from aa where d>'2023-05/26' order by d desc limit 3;
peiyezhuAug 06, 2024ajl_ahmed SQL:create temp table aa asselect udf_my_date_format(f01) d,* from Sheet1 ;select f01 from aa where d>'2023-05/26' order by d desc limit 3;
SergeiBaklanMVPAug 05, 2024ajl_ahmed As variant =IFERROR( AGGREGATE(15,6,C7:C13/(C7:C13>F5), {1;2;3} ), "no such")Book14 (1).xlsx11 KB
