Excel Formulas to List Holidays between Two Dates ~ Easy Tips!!

Have you ever tried to list out the holidays between two dates? In this guide, we will show the easy tricks to get them in Excel quickly. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

Use the below formula to list out the holidays between two dates in Excel.

{=TEXTJOIN(“,”,TRUE,IF(dates>=start,IF(dates<=end,holidays,””),””))}

Syntax Explanations:

TEXTJOIN – In Excel, the TEXTJOIN function will help to join values with a given delimiter separating each value.

TRUE – The TRUE function helps to return the value TRUE if the given conditions will be TRUE or Vice Versa.

IF – This function returns one value for a TRUE result, and another for a FALSE result. . Read more on the IF function.

Dates – It specifies the input dates from your worksheet.

Start – It represents the starting date.

End – It represents the ending date.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

First, we will enter the input dates in Column B and holidays in Column C.

Now we have to find the holidays between the two dates given in Column F.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Conclusion:

From this chapter, you can get some clarification on how to find the holidays between two dates in Excel. Hope you like it. If you have any questions , feel free to comment.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

How to Rename Multiple Files using Macros (VBA) in Excel 365?

Excel Formulas to Get Work Hours between Dates with Custom Schedule

How to Find the Last Column of Data in Excel Office 365?

Excel Formulas to Check the Date is within the Last N Days from Today!!