Calculate calendar days w/o holidays

K

ku

Hi, I'm trying to add 8 days to a date - including
weekends but not including holidays. Any suggestions?
 
B

Bob Phillips

KU,

assuming your date is in E1, and the holidays are in J1:J10, try

=E1+8-SUMPRODUCT((J1:J10>=E1)*(J1:J10<=E1+8))
 
B

Bob Phillips

Daniel,

No I definitely meant subtract, as my reading was that the OP wanted to
avoid holidays.However, I think you are right in that I misinterpreted it,
and thus mine won't work for obvious reasons.
 
Top