Excel Formula: Count Holidays Between Two Dates
To count the number of holidays between two dates, the SUMPRODUCT function in Excel can help you.
Syntaxt and Arguments
|Start_date, end_date:the two dates that you want to count holidays between.|
|Holidays:the dates of holidays.|
The formula returns a numeric value.
How this formula works
The holidays are list in the range D3:D10, and the start date and end date locate in cell B3 and B5, now to count the holidays in the given date range, please use below formula:
Press Enter key to get the counting result.
SUMPRODUCT function: multiples two or more columns or arrays together, and then get the sum of products
- Count Weekdays only Between Two Dates
This tutorial provides formulas to count the days excluding weekends and holidays between two dates
- Count Specific Weekday Between Two Dates
This tutorial provides the formula to count a specific weekday between two given dates in Excel.
- Count Days From Today
This tutorial provides the best formula to calculate the difference between a date and today in Excel.
- Convert Weekday in A Date Range
If there is a list of dates, how can you count a certain day of week in such a list of dates?
- Excel WEEKNUM Function
Returns the week number of the given date in a year
- Excel WORKDAY Function
Adds workdays to the given start date and returns a workday
- Excel MONTH Function
The MONTH is used to get the month as integer number (1 to 12) from date
- Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date
- Excel NOW Function
Get the current time and date