View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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!