Find if holiday falls within date range

See my version for counting Thanksgiving..... Easter is a bit trickier......

Do you want to count these separately or get a total count of holidays within the date range? If it's the latter then you could just create a list of all holidays and use NETWORKDAYS.INTL , i.e. for a count of total holidays within the range

=B2-A2+1-NETWORKDAYS.INTL(A2,B2,"0000000",holidays)

Looks like they're using Excel 2007 so the NETWORKDAYS.INTL function isn't available to them.

Count of Easter holidays is going to be brutal!

Originally Posted by Tony Valko

Looks like they're using Excel 2007

True, I read the wrong profile......