Calculates Dates Based on 7 day week excluding Holidays
 

Is there a function similar to networkdays but includes holidays. I want to
calculate the difference between 2 dates excluding holidays but unlike the
networkdays include the weekends.
--
Thanks!

Calculates Dates Based on 7 day week excluding Holidays
 

Try this:

A1 = start date
B1 = end date
G1:G10 = list of holiday dates

=B1-A1+1-SUMPRODUCT(--(G1:G10=A1),--(G1:G10<=B1))

Biff

"Daviv" wrote in message
...
Is there a function similar to networkdays but includes holidays. I want
to
calculate the difference between 2 dates excluding holidays but unlike the
networkdays include the weekends.
--
Thanks!