Find if holiday falls within date range

**icyrius** · 01-03-2013, 11:16 AM

I tested NETWORKDAYS, but this gives you a total count of days. I only need to find the days off. I will also use this formula to test for total number of Thanksgiving holidays included in the range.

**Miraun** · 01-03-2013, 11:36 AM

Originally Posted by icyrius

I tested NETWORKDAYS, but this gives you a total count of days. I only need to find the days off. I will also use this formula to test for total number of Thanksgiving holidays included in the range.

Total days - Total working days = Total days off.