I need to calculate number of public holidays in a date range

[dpaton05]

I have 2 cells, a start date in B13 and a finish date in B14. I need to calculate the number of holidays that are in the range between the 2 dates, including the start and end date. The holidays are stored on sheet2, in the range G87:DO97

 

[MARK858]

Just deduct the public holidays or the public holidays and weekends?

 

[dpaton05]

actually, I found out how to do this.

 

[dpaton05]

Thanks for your reply Mark. This is the formula I used

=SUMPRODUCT((Sheet2!G87:DO97>=B13)*(Sheet2!G87:DO97<=B14))

Holidays are in the range and the start and end date are B13 and B14.