K ku Sep 6, 2003 #1 Hi, I'm trying to add 8 days to a date - including weekends but not including holidays. Any suggestions?
Hi, I'm trying to add 8 days to a date - including weekends but not including holidays. Any suggestions?
B Bob Phillips Sep 6, 2003 #2 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))
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 Sep 6, 2003 #3 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.
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.
