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.

  • 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;

     

4 Replies

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor

    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;

     

  • m_tarler's avatar
    m_tarler
    Bronze 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

Resources