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!
|