Display entries based on date interval

Hi guys, Need your help with this one. I could not attach the xlsx file here, so I uploaded on wetransfer link: https://we.tl/t-s8sAL5y95g I have two tables: Table A and Table B Table A can h...

excel

Formulas and Functions

OliverScheurich
Nov 15, 2023
alecsi
=DROP(REDUCE("",SEQUENCE(ROWS(Tabelle7[TASK])),LAMBDA(x,y,VSTACK(x,HSTACK(IFERROR(EXPAND(INDEX(Tabelle7[TASK],y),INDEX(Tabelle7[end date],y)-INDEX(Tabelle7[start date],y)+1),INDEX(Tabelle7[TASK],y)),SEQUENCE(INDEX(D2:D5,y)-INDEX(Tabelle7[start date],y)+1,1,INDEX(Tabelle7[start date],y),1))))),1)

With Office 365 or Excel for the web you can create a dynamic table and apply this formula. In my example the table name is "Tabelle7".

OliverScheurich

Gold Contributor

Nov 15, 2023

alecsi

=DROP(REDUCE("",SEQUENCE(ROWS(Tabelle7[TASK])),LAMBDA(x,y,VSTACK(x,HSTACK(IFERROR(EXPAND(INDEX(Tabelle7[TASK],y),INDEX(Tabelle7[end date],y)-INDEX(Tabelle7[start date],y)+1),INDEX(Tabelle7[TASK],y)),SEQUENCE(INDEX(D2:D5,y)-INDEX(Tabelle7[start date],y)+1,1,INDEX(Tabelle7[start date],y),1))))),1)

With Office 365 or Excel for the web you can create a dynamic table and apply this formula. In my example the table name is "Tabelle7".

alecsi
Copper Contributor
Nov 15, 2023
OliverScheurich Thank you so much!!
This is excellent!!! solved my problem.

Wish you all the best!
Alecsi

Forum Discussion

Display entries based on date interval

Resources