TEXTJOIN over multiple rows and 3 columns with specific date range

[Allen_Mead]

I want to be able to use the textjoin function to pull data from our CPD table into a summary for the working week, driven by the date on a given Monday (this will be in a separate cell)

The CPD table will be constantly updated and will include old data (as need to keep a record of all undertaken) and future information.

I would like the data to display as a weekday

Really stuck on this, screen shot attached (sorry i cannot install the XL2BB add on as I'm on a work computer) Many thanks for any help!

 

[Fluff]

You're welcome.

 

[Allen_Mead]

I have another variation that I would like to add in. If the date column is empty (sometimes the date is unknown) I would still like to include the row. I assume the sort function would pull the data with a blank date first, is that possible?

 

[Fluff]

Is there anything else that you have forgotten to mention?

 

[Allen_Mead]

Is there anything else that you have forgotten to mention?

No I don't think so. My apologies for adding additional variations, my brief keeps being added to and I've asked the same question. I'll have no further queries on this formula. Many thanks for your time and help, if I could, I'd get you a beer.

 

[Fluff]

Ok, try

=TEXTJOIN(CHAR(10),,BYROW(SORT('CPD-Meetings'!A3:D300,4),LAMBDA(br,IF(OR(INDEX(br,,4)="",AND(INDEX(br,,4)>=D1-7,INDEX(br,,4)<=D1)),TEXTJOIN({": (",") "," "},,TEXT(INDEX(br,,4),"dddd"),CHOOSECOLS(br,2,3,1)),""))))