Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Aug 05, 2024
Solved

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.
excel
Formulas and Functions
office 365
  • peiyezhu's avatar
    peiyezhu
    Aug 06, 2024

    ajl_ahmed 

    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;

     

     

Patrick2788's avatar
Patrick2788
Silver Contributor
Aug 05, 2024

ajl_ahmed 

Another variant into the hopper:

=LET(
    filtered, SORT(FILTER(ListA, ListA > F5, "none"), , -1),
    TAKE(filtered, -3)
)

 

 

Resources