Note: theTEXTJOIN functionis a new function available in Office 365 and Excel 2019.
More than one condition can be tested by nesting IF functions.
List holidays between two dates
To list holidays that occur between two dates, you can use a formula based on the TEXTJOIN and IF functions. In the example shown, the formula in F8 is: {=TEXTJOIN(", ",TRUE,IF(B4:B12>=F5,IF(B4:B12
