Select names for a list if not expired

[mpoirier]

I am trying to create a comma-separated list of names whose associated date has not expired.

I have a data set containing names and expiry dates where column A is Name and column B is Expiry Date.

To create the comma separated list, I believe the TEXTJOIN function will do nicely:
=TEXTJOIN(<delimiter>, <skip empty cells>, <cell range>)

How do I go about conditionally selecting cells for the <cell range> from column A only if the corresponding date in column B has not expired?

Any help is greatly appreciated.

[JohnSUN]

Welcome!
Yes, TEXTJOIN will do this trick:

{=TEXTJOIN(", ";1;IF(B2:B1000<TODAY();"";A2:A1000))}

Do you see {}? This is an array formula - input it with Ctrl+Shift+Enter instead Enter

[mpoirier]

Thank you for helping so promptly!
For others just learning this for the first time like myself:
Enter the function (pasting did not work for me) without the curly braces into the cell and then press Ctrl+Shift+Enter
Array function documentation: https://help.libreoffice.org/7.3/lo/text/scalc/01/04060107.html?DbPAR=CALC